Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Query #2 - MySQL and MS-SQL
Message
De
09/03/2008 05:41:51
Kevin Goff
Pennsylvanie, États-Unis
 
 
À
09/03/2008 03:21:16
Walter Meester
HoogkarspelPays-Bas
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Re: Query #2 - MySQL and MS-SQL
Divers
Thread ID:
01296743
Message ID:
01300149
Vues:
24
Before this, I had two indexes, one on ID and another on ParentID.

I added a third, on all three columns.

The anchor (main) query is using the third index, that's the only difference.
"Run, you clever boy....and remember"
https://www.youtube.com/watch?v=8U4Y2Uv8ArM

"My survival...my living proof"
https://plus.google.com/photos/117162300364810952313/albums/5876836271056272097/5876836294121419858?banner=pwa&pid=5876836294121419858&oid=117162300364810952313
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform