Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Idx vs cdx ???
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01639814
Message ID:
01639819
Vues:
96
>I'm working with an application where they author of the app is using only free tables, and idx vs cdx indexes. I understand all the issues with the free tables and not having them in a DBC -- but I've never even used IDX indexes. I'm wondering if there are any advantages or disadvantages to using IDX indexes. Thanks!

HackFox3 says "In fact, the only reason to use stand-alone indexes at all is to maintain compatibility with other products or older versions that can't read compound index files."

Maybe the app was developed when either of the above were true.

An interesting Google find: https://books.google.ca/books?id=wKNfTHRNkLAC&pg=PA219&lpg=PA219&dq=vfp+standalone+index+file&source=bl&ots=_-bUpZTkWG&sig=w7tIYUSJv1ZNjKCdxlwqhkm6AIU&hl=en&sa=X&ved=0ahUKEwjZrqr_0djOAhUBymMKHchgBAcQ6AEIRjAI#v=onepage&q=vfp%20standalone%20index%20file&f=false

A discussion of the various index types: https://msdn.microsoft.com/en-us/library/xb5dh76z(v=vs.80).aspx
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform