Mensaje
De
26/11/2006 09:45:37
a
Todos
General information
Foro:
Visual FoxPro
Category:
Programación, sintáxis y comandos
Título:
Speeding up like queries
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
ID de la conversación:
01172471
ID del mensaje:
01172471
Views:
55
Hi all,
I'm using a like "%variable_name%" condition in my SQL query for a large table (>1 million records) and it takes a long time for retrieval.
The field is a character field and is already indexed.
Any strategies that can be used to speed up this query?
Thanks in advance.
Yau
I'm using a like "%variable_name%" condition in my SQL query for a large table (>1 million records) and it takes a long time for retrieval.
The field is a character field and is already indexed.
Any strategies that can be used to speed up this query?
Thanks in advance.
Yau