[askdba] Which index is getting used

  • From: drumil narayan <drumilnarayan@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Mon, 6 Dec 2004 09:30:09 +0000 (GMT)

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: