It may...
Regs,
Vivek Agarwal

> It will...
>
>
> Best Regards,
> Ganesh R
> Everest Reporting Team
> DID: +65-6215-8413
> Tel: 215-8413
> HP : +65-9067-8474
>
>
>
> -----Original Message-----
> From: K.P.SuresKumar [mailto:[Email Address Removed] Sent: Friday, May 30, 2003 1:57 PM
> To: LazyDBA.com Discussion
> Subject: Index use..........
>
>
> Hello,
>
> I have table with 3 columns, name call COL1, COL2 , COL3 and those
> columns are primary key (composite). In this case I just want to
confirm
> if execute the following query, will it be use the index?
>
> Select col2,col3
> from test
> where col1 = 22;
>
> Thanks in advance,
>
> K.SuresKumar.
>
>
>
> --------
> Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepag
> e
> To unsubscribe: send a blank email to
oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
> --------
> Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepag
> e
> To unsubscribe: send a blank email to
oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>

Oracle LazyDBA home page