| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Slow deleting records
What do you mean by "bypass", will not update it?
>say:
>DELETE table_name /*+ FULL(table_name) */
>WHERE ....
>
>The hint must commented out and the +sign must not be seperated from
>/* to work. This will bypass any index on the table.
>
>You still have to disable any triggers that might be active.
>
>Dennis..
>
>
Received on Mon Nov 16 1998 - 00:00:00 CST
 |
 |