Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Speed of DBA_TRIGGER_COLS view
I am running a query like this:
select column_name from dba_trigger_cols
where trigger_owner = 'FRED' and trigger_name = 'FREDSTRIGGER';
This takes quite a long time. I tried removing the hint from the view to no avail. Does anyone know how I can speed up this query.
--
Jim Katsos
Quest Software Pty Ltd
http://www.quests.com
tel +61 3 9811 8068
mob 0411088578
Received on Tue Jan 11 2000 - 00:05:11 CST
![]() |
![]() |