Re: index columns
From: Tim Gorman <tim_at_evdbt.com>
Date: Fri, 17 Apr 2015 16:33:20 -0600
Message-ID: <55318A30.8070703_at_evdbt.com>
You're correct and your colleague is incorrect.
Date: Fri, 17 Apr 2015 16:33:20 -0600
Message-ID: <55318A30.8070703_at_evdbt.com>
You're correct and your colleague is incorrect.
On 4/17/15 16:02, Orlando L wrote:
> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Apr 18 2015 - 00:33:20 CEST