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.