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.

Oracle LazyDBA home page