Re: Why this is slow ?
Hi,
How are these indexes defined exactly?
What are the datatypes of the agentid and compid colums?
if they are atually numeric types, try declaring v_agent and v_comp as numeric types too.
Subject
Views
Written By
Posted
3070
December 01, 2005 03:08PM
Re: Why this is slow ?
1368
December 01, 2005 04:16PM
1712
December 02, 2005 03:38AM
1672
December 02, 2005 05:13AM
1628
December 02, 2005 12:26PM
1705
December 02, 2005 09:42AM
1648
December 02, 2005 02:18PM
1666
December 03, 2005 10:03AM
1522
December 03, 2005 10:08AM
1659
December 03, 2005 01:52PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.