Re: Oracle 9i Limitation (Bug?) in Identifying Key Preserved Tablesin Views

Dave Hau wrote:

> Dan, let me know the results of your benchmark tests. I'm doing a huge
> delete at work also and I'd like to know whether the IN approach, or the
> updatable view approach is faster.
>
> <snipped>
>

Why would you think that someone else's results with their init.ora settings, their hardware, their tables, their indexes, and their data would have even the remotest application to your situation?

You need to do your own benchmarks on your own application.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)