Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Optimizing where like SQLs
Message
From
07/11/2002 09:30:28
Yh Yau
Ingenuity Microsystems Sdn Bhd
Kuala Lumpur, Malaysia
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Optimizing where like SQLs
Miscellaneous
Thread ID:
00719764
Message ID:
00719764
Views:
33
Hi all,
I use a query that contain the condition where fieldname like "%searchitem%" in one of my apps to query tables with large numbers of records. Is that a way to optimize the query via Rushmore (ie indexing?)
Thanks
Yau
Next
Reply
Map
View

Click here to load this message in the networking platform