Hi there!

creating index on any column doesn't help if you won't be using it in your
WHERE clause, bet it a single column or composite/compound index






"Cohn Grant " <oracledba-ezmlmshield-x14183414.[Email address protected]
08/01/2005 06:00 PM


To: "LazyDBA Discussion" <[Email address protected]
cc:
Subject: Index help.....


Hello all!

I see a lot of posts here asking for help on indexes, so I hope that I'm
not gonna drive you crazy with another question:
I have the following select that takes ages to run. Any hints on an
index or indexes that may help.

I guess that not knowing the actual data, may make it impossible to
make a suggestion - but here it is anyway:

CURSOR c_update_pacer_inv_items IS
SELECT DISTINCT spare_part, ref_desc_50, DECODE(stk_item_ind, '0', '0',
'Y', '0','1') sii, uom, unit_price,
end_date_active
FROM xx_pacer_invumi;

Many thanks
Grant.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html





Disclaimer

This email (and any attachment/s) is confidential and for viewing only by
the intended recipient/s. If you received this in error, please notify us
immediately and delete all copies. Any unauthorized access to, review,
reproduction, dissemination or other use of the information contained
herein is strictly prohibited. San Miguel Corporation (SMC) does not
guarantee the security of any information electronically transmitted.

SMC is not liable for the proper and complete transmission of the
information contained in this email nor for any delay in its receipt. The
use of email for any unlawful purpose or for any purpose other than as
permitted by SMC is strictly prohibited. Opinions, conclusions and
statements in this email are opinions, conclusions and statements of the
sender and are not necessarily given, endorsed, espoused or expressed by
SMC.

Oracle LazyDBA home page