Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Composite indexes
Message
From
17/01/2001 12:07:56
 
 
To
All
General information
Forum:
Oracle
Category:
Other
Title:
Composite indexes
Miscellaneous
Thread ID:
00464754
Message ID:
00464754
Views:
74
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.
Next
Reply
Map
View

Click here to load this message in the networking platform