Re: Speed Problem with INSTEAD OF INSERT VIEW FOR EACH ROW

stupsnose wrote:
> Hello!
>
> I have got a very complicated view. There are a few thousand rows, an on
> each row there are calculated fields. If i do a select * on that view,
> it is about 2 Minutes until i get an answer. That is no problem so far.
>
> I have got an INSTEAD OF INSERT-Trigger on that view. When i try to
> insert some data, it does nothing about 2 Minutes and then it runs the
> trigger in a few milli-seconds. I think it might be possible, that
> oracle runs the view somehow internal before it runs the trigger. HOW
> CAN I PREVENT ORACLE OF RUNNING the view first? The INSERT _has_ to be
> much faster. CAN someone tell me how i do that?
>
> Thank you very much! Sorry for my english!
> Stefan

1. No version
2. No DDL
3. No DML
4. No Explain Plan
5. No Trace
6. No crystal ball

I was fine with 1-5 but you must supply the crystal ball to get help.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)