Re: perfomance question

[Vernon Hamberg <vhamberg@xxxxxxxxx>]

Doug

Right. Of course, I'm thinking, not of CLRPFM itself, but whatever is done
at the lower levels when that is called. They wouldn't use a CL command to
do anything in the actual SQL engine - I hope.

Again, it's likely that there were good reasons, in the design, for not
doing what I'm suggesting.   ;-)

Vern

At 08:51 AM 10/16/02 -0400, you wrote:
> Vernon,
>
> >Ah, good point - hadn't thought of that. Of course, the optimizer could
> >know there's no journaling on a particular file, so it wouldn't matter.
>
> Aside from journaling, triggers are another issue.  A file with a delete
> trigger
> cannot have a CLRPFM operation performed, while it can do an iterative
> delete of
> all records.
>
> Doug