Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Speed Problem with INSTEAD OF INSERT VIEW FOR EACH ROW
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 Received on Tue Jun 07 2005 - 07:42:18 CDT