You're right, I thought you're referring to something else. Yes, if it set
on Choose, the optimizer could "walk" on full table if it's more efficient,
for instance



----- Original Message -----
From: <vivek.[Email Address Removed] <[Email Address Removed] <[Email Address Removed] Friday, May 30, 2003 9:13 AM
Subject: Re: Index use..........


> Basics...
> depends upon Cardinality of the that single column( col1), Col1 is not
> the unique as primary key on three columns(composite key)
> That's why, "it may"
> Regs,
> Vivek Agarwal.



Oracle LazyDBA home page