Re: DELETE and WHERE

From: RC <rclarence_at_tyc.com>
Date: Wed, 05 Jan 2000 21:30:20 GMT
Message-ID: <s77dvc7dhu8124@corp.supernews.com>

GERNEZ wrote:
>
>
> Hello,
>
> Does anyone know, it is possible to optimize a delete in a big table
> ????
> (the table is NOLOGGING option and i have a condition in this delete)
>
>
> Thanks
>
> Certainly if you use a column in the where clause that is indexed you
will get a nice performance boost.

HTH RC

--
Posted via CNET Help.com
http://www.help.com/ Received on Wed Jan 05 2000 - 15:30:20 CST

This message: [ Message body ]
Next message: RC: "Re: How many of you run multi apps in one instance?"
Previous message: argosy22_at_my-deja.com: "Nested tables - what are the uses?"
In reply to: GERNEZ: "DELETE and WHERE"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US