Can you check the explain plans of sample queries before re-building the indexes?
Also, check the status of the indexes (from user_indexes).
What type of indexes are these (bit map)?

- Kirti

--- RAMA KORADA <[Email Address Removed] wrote:
> Apps group (people soft) are claming that batch jobs are running slow,
> jobs are
> doing full table scan even there are indexes on the tables. Once we
> drop those
> indexes and recreate then the indexes are used. what would be the
> problem
> (are there any parameter that need to set). The end user wishes to know
> why
> the indexes are being bypassed and why they need to be recreated every
> time to
> force usage. How can we provide them a workaround to guarantee that
> indexes
> get used every time.
>
> Thanks
> Krishna
> Dallas Tx
>
>

__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
Oracle LazyDBA home page