using multi column index for single column usage
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 ?