Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Composite indexes
Message
De
17/01/2001 12:07:56
 
 
À
Tous
Information générale
Forum:
Oracle
Catégorie:
Autre
Titre:
Composite indexes
Divers
Thread ID:
00464754
Message ID:
00464754
Vues:
75
Does Oracle have composite indexes? - e.g., in VFP we can
INDEX ON last_name+first_name TAG fullname
If it does,
1) is it more efficient to use a composite index or a separate index on each field
2) if the composite index is more efficient, can you create a composite index on numeric fields w/o converting them to strings first?

TIA
Insanity: Doing the same thing over and over and expecting different results.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform