[askdba] Re: Which index is getting used
- From: Ganesh Raja <ganesh.raja@xxxxxxxxx>
- To: askdba@xxxxxxxxxxxxx
- Date: Tue, 7 Dec 2004 09:38:07 +0000
The difference between Select * and Select Desired_col is the Lesser
Number of LIO/PIO;s
HTH
On Mon, 6 Dec 2004 09:30:09 +0000 (GMT), drumil narayan
<drumilnarayan@xxxxxxxxx> wrote:
> Dear all,
>
> How should i find out which index is getting used on
> following query in a cursor
>
> SELECT * from gin_con
> where bill_num like
> nvl(:BILL_TRAN_HDR.bill_num,bill_num)
> AND VND_CD like nvl(:BILL_TRAN_HDR.VND_CD,VND_CD)
> and DOC_NUM like nvl(:BILL_TRAN_HDR.DOC_NUM,DOC_NUM)
> and DOC_TYPE = nvl(:BILL_TRAN_HDR.DOC_TYPE,DOC_TYPE)
> AND DOC_YR = nvl(:BILL_TRAN_HDR.DOC_YR,DOC_YR)
> and bill_dt = nvl(:BILL_TRAN_HDR.bill_dt,bill_dt)
> and DOC_dt = nvl(:BILL_TRAN_HDR.GIN_dt,DOC_dt);
>
> and secondly i want to ask performance wise
> what is the difference in
>
> select * from table_name ;
> and
> select desired_column_list from table_name;
>
> TIA..drumil
>
>
> ________________________________________________________________________
> Yahoo! India Matrimony: Find your life partner online
> Go to: http://yahoo.shaadi.com/india-matrimony
>
>
Other related posts:
