How to run faster Query ? (Herman Ghislain) 
Author Message
 How to run faster Query ? (Herman Ghislain)
When i use a query with index secondary  to seek a value this this speed.

But when a seek a value contain a jockers (Sample : DUPONT..) this is very
 small !!!

How optimise this ?

thank for avance.




Tue, 07 Jul 1998 03:00:00 GMT
 How to run faster Query ? (Herman Ghislain)

A dot-dot query pattern isn't the same as looking
for an exact match.. Pdox can use the index as
a starting point only.. and if the leading part of
the pattern is the dot-dot, then the index doesn't
get used at all..

--
Steve Green - Diamond Software Group - Waldorf Maryland USA
CompuServe 71333.2362 - Prodigy TBMG62A -  I am a member of
Borland's TeamB Tech Support staff for PdoxDOS but I do not
represent Borland International in any official capacity.



Wed, 08 Jul 1998 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Slow query execution through JDBC - runs fast in Query Analyzer

2. query runs faster on a remote machine

3. Query parallelisim - SELECT runs faster on 1 processor?

4. VB code running in IDE and querying OLAP Server faster than compiled one

5. How to make this SQL query run faster

6. SQL Server queries run fast in domain, slooowwww in workgroup set ting

7. How can I run fast queries asynchronously

8. Slow query runs fast after saving in access???

9. How to run faster the Query (QBE)

10. make queries run faster?

11. Making a query run faster

12. George Herman, are you out there?


 
Powered by phpBB® Forum Software