Re: TRUNC or BETWEEN?

On 2 Feb 1995 20:36:09 GMT, Ed Hillmann (Edward_Hillman_at_mail.amsinc.com) wrote:

> I'm wondering if either of these functions/methods in Oracle 7 will turn off any
> indexes and perform full-table scans.
 <...>
> but were told that between shut off indexes. Now, I'm being told that TRUNC() turns off
> indexes. Anyone ever hear of either of these? Thanks.

Applying any function to a retrieved column value prevents the use of an index on that column (because the values of the function are not stored in the index).

"Between" in itself will not prevent the use of an index.

iain.

--

..............................................................................
Iain Massey   Information Services Manager
              J-Corp Pty Ltd             ACN 009 063 076    "Building the
              Perth, Western Australia                        spirit of
Phone:        +61 9 340 3555                               free enterprise"
Fax:          +61 9 340 3504
Email:        iain_at_jcorp.DIALix.oz.au
..............................................................................