Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Any corruption problems using compound indexes?
Message
 
 
À
17/05/2010 16:53:57
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 7 SP1
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01464942
Message ID:
01464946
Vues:
66
There's nothing in compound indexes itself that would increase a chance of corruption but they do increase size of the index file itself. Did you look into other ways to improve performance?

>
>We are using compound indexes to improve our data access speed which has improved. We are sometime getting our indexes corrupted and don't know if it's related.
>Does anyone have any experience or knowledge about the "does and don'ts" of using compound indexes? Are they OK to use or are there reliability issues.
>
>Examples of indexes I'm using:
>
>*----- Views Defined for Compound Indexes
>INDEX ON STR(iCustomer_Masteriid) + ctrans_type + cTrans_No 					 TAG CDX_1
>INDEX ON STR(iCustomer_Masteriid) + ctrans_type + cTrans_No + STR(iapply_seq) + cRate_Table_Code TAG CDX_2
>
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform