Indexes and ROWNUM.

Hi...
Simple question....

I wanted to know if I use the ROWNUM in the WHERE clause it disables the indexed.
For example: (In the case I have many records with FLD1 = 1)

   UPDATE MYTABLE SET FLD2 = 'HELLO WORD' WHERE FLD1 = 1 AND ROWNUM < 2; If the table has an index, the UPDATE will do a FullScan or it will use the index if there is any!?!?

Thanks in advance...

Daniel Received on Wed Apr 07 2004 - 14:44:03 CDT