Database Tuning (MOSC)

MOSC Banner

using multi column index for single column usage

in Database Tuning (MOSC) 2 commentsAnswered ✓

Simple question (to which I can't find confirmation): if you have an index, a regular standard index on a regular table, on columns A and B (in that order)


Is that index now also by definition an index that behaves like an index as if I made one only for column A, and used it in a query just by referring to column A, not to column A and B ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center