index columns

  • From: Orlando L <oralrnr@xxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 17 Apr 2015 17:02:25 -0500

All

My colleague and I got into a discussion about indexes. I feel that putting
the most selective column first while creating multi column indexes is the
correct approach, followed by second most selective column as the second
column in the index and so on. My colleague feels that the order does not
matter. Can someone clarify.

OL

Other related posts: