I've a select query that brings back matching records for a specific document number and company code. There's no index containing these, so I'm creating one. There are ~40 company codes in the system and many thousands of document numbers per company code.
Is there a preferred order for the index? I.e. should I used CoCode, DocNum or DocNum CoCode? Or does it not matter?
(Oracle 11.2)
Is there a preferred order for the index? I.e. should I used CoCode, DocNum or DocNum CoCode? Or does it not matter?
(Oracle 11.2)
Comment