I am firing a query which uses a table hint /*+ USE_CONCAT */ on a table which 250 million data with 13 indexes on it. The problem is query is taking a lot of time to execute i.e. more than 3 minutes.
Query :
[code=oracle]
SELECT /*+ USE_CONCAT */ COUNT(*) FROM DI_MATCH_KEY
WHERE NORM_COUNTRY_CD = 'US'
AND ((( NORM_CONAME_KEY 1 ='WILM I' OR
NORM_CONAME_KEY 2 = 'WILM I' OR NORM_CONAME_KEY 23 =...
suneelchetty
Last Activity: Feb 18 '08, 10:05 AM
Joined: Feb 13 '08
Location:
-
suneelchetty started a topic Sub : Query to be tuned which uses a table hint /*+ USE_CONCAT */ in Oracle 10g.in OracleSub : Query to be tuned which uses a table hint /*+ USE_CONCAT */ in Oracle 10g.
No activity results to display