Numeric Operators in SQL Where clauses
> On Feb 2, 2018, at 1:35 PM, Clifford Ilkay <cilkay@gmail.com> wrote:
>
> You should be aware that if you have large datasets and you’re doing a LIKE
> on a low-cardinality (lots of similar or same data) column, the query will
> do a table scan (evaluate all rows) and performance will suffer.
Is this true even if the column’s searched with ‘LIKE’ are indexed?
_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en@lists.omnis-dev.com