Re: UPDATE

Have you tested the full scan verse the use of the index? Since Oracle is able to limit the query to using the one partion of the partioned table the full scan where each block is accessed once may be faster than using the index which could require revisiting table blocks.

• Mark D Powell --