Optimizing where like SQLs

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Optimizing where like SQLs

Message

From

07/11/2002 10:07:39

Yh Yau
Ingenuity Microsystems Sdn Bhd
Kuala Lumpur, Malaysia

07/11/2002 09:35:09

Sergey Berezniker
New York, United States

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Re: Optimizing where like SQLs

Miscellaneous

Thread ID:

00719764

Message ID:

00719784

Views:

Sergey,
What about SQL "%searchitem".
Also what about x-y>0 type of conditions, are these optimizable? ie can I create an index on x-y to optimize the query?

Thanks
Yau

Map

View

Click here to load this message in the networking platform