RE: Index Rebuilds

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Sat, 5 Aug 2006 15:29:39 +0200
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF615117@MSXVS04.trivadis.com>

Anand

> Range Scan is used if the leading columns of the index are part of the
> equality predicate.

Of course you are right, equality predicates that are not applied through a unique index Oracle uses a RANGE SCAN. When I wrote that sentence I was thinking to SQL and not to Oracle's execution plans. I.e. I was thinking to (un)bounded searches.

Regards,
Chris

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Aug 05 2006 - 08:29:39 CDT