Home » SQL & PL/SQL » SQL & PL/SQL » Help need in tuning this query
Help need in tuning this query [message #235102] Fri, 04 May 2007 01:34 Go to next message
sibgat
Messages: 45
Registered: November 2006
Location: Chennai
Member

Hi
i have pasted the query below while analyzing the explain plan for this query, i got 3 full table scans, when i change rownum to 1 in the query, i got no full table scans, i am using rownum for fetching records in sets like 1 to 50 etc.

--------------------
SELECT TEMPTABLE2.* 
 FROM (
 SELECT TEMPTABLE1.*, ROWNUM AS UNIQUEID  
 FROM ( SELECT  newOutersql.LSY_SYSTEM_ID,  
        newOutersql.LAC_LEG_ACCNR_NR, newOutersql.COU_ISO_ID, 
         newOutersql.CUS_NAME_KEY_TX, newOutersql.CUS_COMPANY_NM,  
         newOutersql.CUS_TITLE_CD, newOutersql.CUS_FORE_NM, 
         newOutersql.CUS_INIT_NM,  newOutersql.CUS_SUR_NM, 
         newOutersql.CUS_DEPT_NM,  newOutersql.CUS_ID,  
          newOutersql.TEL_NR, newOutersql.LOC_SORT_NAME, 
          newOutersql.CLO_FLAT_NR, newOutersql.CLO_HOUSE_NR,  
          newOutersql.CLO_STREET_NM, newOutersql.CLO_TOWN_NM, 
          newOutersql.CLO_POSTAL_CD, newOutersql.CUS_DEBTOR_STAT_CD,  
          newOutersql.DRK_ID_DELETE, newOutersql.CUF_CD, 
       newOutersql.CUS_ID_PARENT,  
      (CASE WHEN newOutersql.CUS_ID_PARENT  >0 AND  childCount = 0 THEN 'C' 
       WHEN newOutersql.CUS_ID_PARENT  >0  AND childCount > 0 THEN 'B'  
       WHEN ( newOutersql.CUS_ID_PARENT  IS NULL OR newOutersql.CUS_ID_PARENT <=0 ) 
       AND childCount > 0 THEN 'P'  ELSE 'N'  END  ) childOrParent,
        newOutersql.CUS_SORT_NAME 
        FROM  ( SELECT outerLegAcc.LSY_SYSTEM_ID, 
        outerLegAcc.LAC_LEG_ACCNR_NR, outerCus.COU_ISO_ID, 
        outerCus.CUS_NAME_KEY_TX, outerCus.CUS_COMPANY_NM,
        outerCus.CUS_TITLE_CD, outerCus.CUS_FORE_NM,
        outerCus.CUS_INIT_NM, outerCus.CUS_SUR_NM, 
        outerCus.CUS_DEPT_NM, outerCus.CUS_ID, 
        outerCus.CUS_TEL_1_NR||outerCus.CUS_TEL_2_NR TEL_NR, outerLoc.CLO_ADDR_LINE_1_TX ||
        outerLoc.CLO_HOUSE_NR || outerLoc.CLO_FLAT_NR ||outerLoc.CLO_STREET_NM as LOC_SORT_NAME , 
        outerLoc.CLO_FLAT_NR, outerLoc.CLO_HOUSE_NR, outerLoc.CLO_STREET_NM,
        outerLoc.CLO_TOWN_NM, outerLoc.CLO_POSTAL_CD, outerCus.CUS_DEBTOR_STAT_CD,
        outerCus.DRK_ID_DELETE, outerLocFunc.CUF_CD, outerCus.CUS_ID_PARENT , 
        ( SELECT count(innerCus.CUS_ID) FROM CNRCUV01 innerCus 
          WHERE innerCus.CUS_ID_PARENT = outerCus.CUS_ID  ) childCount ,
outerCus.CUS_COMPANY_NM || outerCus.CUS_SUR_NM   || outerCus.CUS_FORE_NM as CUS_SORT_NAME  
FROM (( (CNRCUV01 outerCus  JOIN CNRCLV01 outerLoc ON outerCus.CUS_ID = outerLoc.CUS_ID 
AND outerLoc.CLO_DELETE_IN = 'N' )  JOIN CNRLFV01 outerLocFunc ON outerLocFunc.CUS_ID = outerLoc.CUS_ID 
AND outerLoc.CLO_ID = outerLocFunc.CLO_ID  
AND (outerLocFunc.CUF_CD = 'M') AND outerLocFunc.CLF_DELETE_IN = 'N')) 
JOIN CNRLAV01 outerLegAcc ON outerLegAcc.CUS_ID = outerCus.CUS_ID  
AND outerLegAcc.CUS_DATA_TYPE_CD ='CUS'  
JOIN CNRACV01 ca  ON outerCus.CUS_ID = ca.CUS_ID AND ca.DRK_ID_DELETE <> 'Y' 
AND  outerLegAcc.CAC_ID = ca.CAC_ID AND outerLegAcc.CUS_ID = ca.CUS_ID  
WHERE  ca.CAC_TRADE_IN = 'Y'  AND  EXISTS (SELECT 1 FROM CNRCUV01 cus 
JOIN CNRLAV01 legAcc ON cus.CUS_ID = legAcc.CUS_ID AND legAcc.LAC_DELETE_IN = 'N' 
JOIN CNRACV01 ca  ON cus.CUS_ID = ca.CUS_ID AND ca.DRK_ID_DELETE <> 'Y' 
AND  legAcc.CAC_ID = ca.CAC_ID AND legAcc.CUS_ID = ca.CUS_ID 
LEFT OUTER JOIN CNRCCV01 con ON cus.CUS_ID = con.CUS_ID AND con.CPF_DELETE_IN = 'N' 
JOIN CNRCLV01 loc ON cus.CUS_ID = loc.CUS_ID AND loc.CLO_DELETE_IN = 'N' 
JOIN CNRLFV01 locFunc ON loc.CUS_ID = locFunc.CUS_ID AND loc.CLO_ID = locFunc.CLO_ID  
AND locFunc.CLF_DELETE_IN = 'N' AND locFunc.CUF_CD = 'M'   WHERE
cus.COU_ISO_ID = loc.COU_ISO_ID_CUS AND  loc.COU_ISO_ID_CUS = 'GB' AND
UPPER(con.CPF_SUR_NM) = 'MADHU' AND  legAcc.CUS_DATA_TYPE_CD='CUS' 
AND cus.DRK_ID_DELETE NOT IN ('M', 'C') AND  cus.CUS_INTERNAL_IN = 'N' 
AND ca.CAC_TRADE_IN = 'Y' AND  locFunc.CUF_CD = 'M'  
AND cus.CUS_ID = outerCus.CUS_ID ) ) newOutersql  )  TEMPTABLE1 ) TEMPTABLE2  
WHERE TEMPTABLE2.UNIQUEID > 0  AND TEMPTABLE2.UNIQUEID <= 50

 --------------------
Plan										Bytes	Cost
SELECT STATEMENT  ALL_ROWSCardinality: 0  CPU Cost: 289,026,357  IO Cost: 1,081  Time: 14  										0	1,108
	29 VIEW CNADMIN. Cardinality: 0  CPU Cost: 289,026,357  IO Cost: 1,081  Time: 14  									29 0	29 1,108
		28 COUNT  								28 	28 
			27 FILTER  							27 	27 
				10 NESTED LOOPS  Cardinality: 1  CPU Cost: 288,943,740  IO Cost: 1,074  Time: 14  						10 162	10 1,101
					8 NESTED LOOPS  Cardinality: 1  CPU Cost: 288,935,568  IO Cost: 1,074  Time: 14  					8 148	8 1,101
						5 HASH JOIN  Temp Space: 525,000  Cardinality: 1  CPU Cost: 288,918,416  IO Cost: 1,072  Time: 14  				5 94	5 1,099
							1 TABLE ACCESS FULL TABLE CNADMIN.CNRACT01 Cardinality: 17,806  CPU Cost: 26,857,702  IO Cost: 93  Time: 2  			1 302,702	1 95
							4 HASH JOIN  Cardinality: 6,973  CPU Cost: 251,990,705  IO Cost: 916  Time: 12  			4 536,921	4 939
								2 TABLE ACCESS FULL TABLE CNADMIN.CNRLAT01 Cardinality: 6,973  CPU Cost: 39,226,070  IO Cost: 201  Time: 3  		2 139,460	2 205
								3 TABLE ACCESS FULL TABLE CNADMIN.CNRCUT01 Cardinality: 105,827  CPU Cost: 195,706,783  IO Cost: 715  Time: 9  		3 6,032,139	3 733
						7 TABLE ACCESS BY INDEX ROWID TABLE CNADMIN.CNRCLT01 Cardinality: 1  CPU Cost: 17,153  IO Cost: 2  Time: 1  				7 54	7 2
							6 INDEX RANGE SCAN INDEX (UNIQUE) CNADMIN.CNNCLT01 Cardinality: 1  CPU Cost: 8,371  IO Cost: 1  Time: 1  			6 	6 1
					9 INDEX UNIQUE SCAN INDEX (UNIQUE) CNADMIN.CNNLFT01 Cardinality: 1  CPU Cost: 8,171  IO Cost: 0  Time: 1  					9 14	9 0
				26 MERGE JOIN CARTESIAN  Cardinality: 1  CPU Cost: 82,617  IO Cost: 7  Time: 1  						26 89	26 7
					22 NESTED LOOPS  Cardinality: 1  CPU Cost: 63,882  IO Cost: 5  Time: 1  					22 73	22 5
						19 NESTED LOOPS  Cardinality: 1  CPU Cost: 46,879  IO Cost: 4  Time: 1  				19 58	19 4
							16 MERGE JOIN CARTESIAN  Cardinality: 1  CPU Cost: 30,986  IO Cost: 3  Time: 1  			16 41	16 3
								13 NESTED LOOPS  Cardinality: 1  CPU Cost: 22,614  IO Cost: 2  Time: 1  		13 27	13 2
									11 INDEX RANGE SCAN INDEX CNADMIN.TEMP_IDX2 Cardinality: 1  CPU Cost: 14,443  IO Cost: 1  Time: 1  	11 14	11 1
									12 INDEX RANGE SCAN INDEX CNADMIN.TEMP_IDX5 Cardinality: 1  CPU Cost: 8,171  IO Cost: 1  Time: 1  	12 13	12 1
								15 BUFFER SORT  Cardinality: 1  CPU Cost: 22,814  IO Cost: 2  Time: 1  		15 14	15 2
									14 INDEX RANGE SCAN INDEX (UNIQUE) CNADMIN.CNNLFT01 Cardinality: 1  CPU Cost: 8,371  IO Cost: 1  Time: 1  	14 14	14 1
							18 TABLE ACCESS BY INDEX ROWID TABLE CNADMIN.CNRACT01 Cardinality: 1  CPU Cost: 15,893  IO Cost: 1  Time: 1  			18 17	18 1
								17 INDEX UNIQUE SCAN INDEX (UNIQUE) CNADMIN.CNNACT01 Cardinality: 1  CPU Cost: 8,171  IO Cost: 0  Time: 1  		17 	17 0
						21 TABLE ACCESS BY INDEX ROWID TABLE CNADMIN.CNRCLT01 Cardinality: 1  CPU Cost: 17,003  IO Cost: 1  Time: 1  				21 15	21 1
							20 INDEX UNIQUE SCAN INDEX (UNIQUE) CNADMIN.CNNCLT01 Cardinality: 1  CPU Cost: 8,171  IO Cost: 0  Time: 1  			20 	20 0
					25 BUFFER SORT  Cardinality: 1  CPU Cost: 65,614  IO Cost: 6  Time: 1  					25 16	25 6
						24 TABLE ACCESS BY INDEX ROWID TABLE CNADMIN.CNRCCT01 Cardinality: 1  CPU Cost: 18,735  IO Cost: 2  Time: 1  				24 16	24 2
							23 INDEX RANGE SCAN INDEX (UNIQUE) CNADMIN.CNNCCT01 Cardinality: 3  CPU Cost: 8,571  IO Cost: 1  Time: 1  			23 	23 1
---------------------

After changing rownum to 1
------------------

SELECT TEMPTABLE2.* 
 FROM (
 SELECT TEMPTABLE1.*, 1 AS UNIQUEID  
 FROM ( SELECT  newOutersql.LSY_SYSTEM_ID,  
        newOutersql.LAC_LEG_ACCNR_NR, newOutersql.COU_ISO_ID, 
         newOutersql.CUS_NAME_KEY_TX, newOutersql.CUS_COMPANY_NM,  
         newOutersql.CUS_TITLE_CD, newOutersql.CUS_FORE_NM, 
         newOutersql.CUS_INIT_NM,  newOutersql.CUS_SUR_NM, 
         newOutersql.CUS_DEPT_NM,  newOutersql.CUS_ID,  
          newOutersql.TEL_NR, newOutersql.LOC_SORT_NAME, 
          newOutersql.CLO_FLAT_NR, newOutersql.CLO_HOUSE_NR,  
          newOutersql.CLO_STREET_NM, newOutersql.CLO_TOWN_NM, 
          newOutersql.CLO_POSTAL_CD, newOutersql.CUS_DEBTOR_STAT_CD,  
          newOutersql.DRK_ID_DELETE, newOutersql.CUF_CD, 
       newOutersql.CUS_ID_PARENT,  
      (CASE WHEN newOutersql.CUS_ID_PARENT  >0 AND  childCount = 0 THEN 'C' 
       WHEN newOutersql.CUS_ID_PARENT  >0  AND childCount > 0 THEN 'B'  
       WHEN ( newOutersql.CUS_ID_PARENT  IS NULL OR newOutersql.CUS_ID_PARENT <=0 ) 
       AND childCount > 0 THEN 'P'  ELSE 'N'  END  ) childOrParent,
        newOutersql.CUS_SORT_NAME 
        FROM  ( SELECT outerLegAcc.LSY_SYSTEM_ID, 
        outerLegAcc.LAC_LEG_ACCNR_NR, outerCus.COU_ISO_ID, 
        outerCus.CUS_NAME_KEY_TX, outerCus.CUS_COMPANY_NM,
        outerCus.CUS_TITLE_CD, outerCus.CUS_FORE_NM,
        outerCus.CUS_INIT_NM, outerCus.CUS_SUR_NM, 
        outerCus.CUS_DEPT_NM, outerCus.CUS_ID, 
        outerCus.CUS_TEL_1_NR||outerCus.CUS_TEL_2_NR TEL_NR, outerLoc.CLO_ADDR_LINE_1_TX ||
        outerLoc.CLO_HOUSE_NR || outerLoc.CLO_FLAT_NR ||outerLoc.CLO_STREET_NM as LOC_SORT_NAME , 
        outerLoc.CLO_FLAT_NR, outerLoc.CLO_HOUSE_NR, outerLoc.CLO_STREET_NM,
        outerLoc.CLO_TOWN_NM, outerLoc.CLO_POSTAL_CD, outerCus.CUS_DEBTOR_STAT_CD,
        outerCus.DRK_ID_DELETE, outerLocFunc.CUF_CD, outerCus.CUS_ID_PARENT , 
        ( SELECT count(innerCus.CUS_ID) FROM CNRCUV01 innerCus 
          WHERE innerCus.CUS_ID_PARENT = outerCus.CUS_ID  ) childCount ,
outerCus.CUS_COMPANY_NM || outerCus.CUS_SUR_NM   || outerCus.CUS_FORE_NM as CUS_SORT_NAME  
FROM (( (CNRCUV01 outerCus  JOIN CNRCLV01 outerLoc ON outerCus.CUS_ID = outerLoc.CUS_ID 
AND outerLoc.CLO_DELETE_IN = 'N' )  JOIN CNRLFV01 outerLocFunc ON outerLocFunc.CUS_ID = outerLoc.CUS_ID 
AND outerLoc.CLO_ID = outerLocFunc.CLO_ID  
AND (outerLocFunc.CUF_CD = 'M') AND outerLocFunc.CLF_DELETE_IN = 'N')) 
JOIN CNRLAV01 outerLegAcc ON outerLegAcc.CUS_ID = outerCus.CUS_ID  
AND outerLegAcc.CUS_DATA_TYPE_CD ='CUS'  
JOIN CNRACV01 ca  ON outerCus.CUS_ID = ca.CUS_ID AND ca.DRK_ID_DELETE <> 'Y' 
AND  outerLegAcc.CAC_ID = ca.CAC_ID AND outerLegAcc.CUS_ID = ca.CUS_ID  
WHERE  ca.CAC_TRADE_IN = 'Y'  AND  EXISTS (SELECT 1 FROM CNRCUV01 cus 
JOIN CNRLAV01 legAcc ON cus.CUS_ID = legAcc.CUS_ID AND legAcc.LAC_DELETE_IN = 'N' 
JOIN CNRACV01 ca  ON cus.CUS_ID = ca.CUS_ID AND ca.DRK_ID_DELETE <> 'Y' 
AND  legAcc.CAC_ID = ca.CAC_ID AND legAcc.CUS_ID = ca.CUS_ID 
LEFT OUTER JOIN CNRCCV01 con ON cus.CUS_ID = con.CUS_ID AND con.CPF_DELETE_IN = 'N' 
JOIN CNRCLV01 loc ON cus.CUS_ID = loc.CUS_ID AND loc.CLO_DELETE_IN = 'N' 
JOIN CNRLFV01 locFunc ON loc.CUS_ID = locFunc.CUS_ID AND loc.CLO_ID = locFunc.CLO_ID  
AND locFunc.CLF_DELETE_IN = 'N' AND locFunc.CUF_CD = 'M'   WHERE
cus.COU_ISO_ID = loc.COU_ISO_ID_CUS AND  loc.COU_ISO_ID_CUS = 'GB' AND
UPPER(con.CPF_SUR_NM) = 'MADHU' AND  legAcc.CUS_DATA_TYPE_CD='CUS' 
AND cus.DRK_ID_DELETE NOT IN ('M', 'C') AND  cus.CUS_INTERNAL_IN = 'N' 
AND ca.CAC_TRADE_IN = 'Y' AND  locFunc.CUF_CD = 'M'  
AND cus.CUS_ID = outerCus.CUS_ID ) ) newOutersql  )  TEMPTABLE1 ) TEMPTABLE2  
WHERE TEMPTABLE2.UNIQUEID > 0  AND TEMPTABLE2.UNIQUEID <= 50

 ---------------

Plan															Bytes	Cost
SELECT STATEMENT  ALL_ROWSCardinality: 1  CPU Cost: 33,000,482  IO Cost: 163  Time: 2  															175	166
	2 SORT AGGREGATE  Cardinality: 1  														2 2	2 
		1 INDEX RANGE SCAN INDEX (UNIQUE) CNADMIN.CNQCUT03 Cardinality: 62  CPU Cost: 14,643  IO Cost: 2  Time: 1  													1 124	1 2
	4 SORT AGGREGATE  Cardinality: 1  														4 2	4 
		3 INDEX RANGE SCAN INDEX (UNIQUE) CNADMIN.CNQCUT03 Cardinality: 62  CPU Cost: 14,643  IO Cost: 2  Time: 1  													3 124	3 2
	6 SORT AGGREGATE  Cardinality: 1  														6 2	6 
		5 INDEX RANGE SCAN INDEX (UNIQUE) CNADMIN.CNQCUT03 Cardinality: 62  CPU Cost: 14,643  IO Cost: 2  Time: 1  													5 124	5 2
	36 NESTED LOOPS  Cardinality: 1  CPU Cost: 33,000,482  IO Cost: 163  Time: 2  														36 175	36 166
		33 NESTED LOOPS  Cardinality: 1  CPU Cost: 32,984,589  IO Cost: 162  Time: 2  													33 158	33 165
			30 NESTED LOOPS  Cardinality: 1  CPU Cost: 32,968,846  IO Cost: 160  Time: 2  												30 138	30 163
				28 NESTED LOOPS  Cardinality: 1  CPU Cost: 32,960,675  IO Cost: 160  Time: 2  											28 124	28 163
					25 NESTED LOOPS  Cardinality: 1  CPU Cost: 32,943,522  IO Cost: 158  Time: 2  										25 70	25 161
						22 VIEW VIEW SYS.VW_SQ_1 Cardinality: 1  CPU Cost: 22,068,215  IO Cost: 157  Time: 2  									22 13	22 159
							21 SORT UNIQUE  Cardinality: 1  								21 89	21 
								20 NESTED LOOPS  Cardinality: 1  CPU Cost: 22,068,215  IO Cost: 157  Time: 2  							20 89	20 159
									18 NESTED LOOPS  Cardinality: 1  CPU Cost: 22,060,044  IO Cost: 157  Time: 2  						18 75	18 159
										15 NESTED LOOPS  Cardinality: 1  CPU Cost: 22,041,131  IO Cost: 155  Time: 2  					15 60	15 157
											12 HASH JOIN  Cardinality: 10  CPU Cost: 21,882,202  IO Cost: 145  Time: 2  				12 430	12 147
												10 HASH JOIN  Cardinality: 181  CPU Cost: 14,218,455  IO Cost: 86  Time: 2  			10 5,430	10 87
													8 TABLE ACCESS BY INDEX ROWID TABLE CNADMIN.CNRCCT01 Cardinality: 181  CPU Cost: 22,484  IO Cost: 2  Time: 1  		8 2,896	8 2
														7 INDEX RANGE SCAN INDEX CNADMIN.TEMP_IDC1 Cardinality: 3  CPU Cost: 14,443  IO Cost: 1  Time: 1  	7 	7 1
													9 INDEX FAST FULL SCAN INDEX CNADMIN.TEMP_IDX2 Cardinality: 60,762  CPU Cost: 2,663,419  IO Cost: 84  Time: 2  		9 850,668	9 84
												11 INDEX FAST FULL SCAN INDEX CNADMIN.TEMP_IDX5 Cardinality: 3,487  CPU Cost: 1,858,696  IO Cost: 59  Time: 1  			11 45,331	11 59
											14 TABLE ACCESS BY INDEX ROWID TABLE CNADMIN.CNRACT01 Cardinality: 1  CPU Cost: 15,893  IO Cost: 1  Time: 1  				14 17	14 1
												13 INDEX UNIQUE SCAN INDEX (UNIQUE) CNADMIN.CNNACT01 Cardinality: 1  CPU Cost: 8,171  IO Cost: 0  Time: 1  			13 	13 0
										17 TABLE ACCESS BY INDEX ROWID TABLE CNADMIN.CNRCLT01 Cardinality: 1  CPU Cost: 18,913  IO Cost: 2  Time: 1  					17 15	17 2
											16 INDEX RANGE SCAN INDEX (UNIQUE) CNADMIN.CNNCLT01 Cardinality: 1  CPU Cost: 8,371  IO Cost: 1  Time: 1  				16 	16 1
									19 INDEX UNIQUE SCAN INDEX (UNIQUE) CNADMIN.CNNLFT01 Cardinality: 1  CPU Cost: 8,171  IO Cost: 0  Time: 1  						19 14	19 0
						24 TABLE ACCESS BY INDEX ROWID TABLE CNADMIN.CNRCUT01 Cardinality: 1  CPU Cost: 16,903  IO Cost: 1  Time: 1  									24 57	24 1
							23 INDEX UNIQUE SCAN INDEX (UNIQUE) CNADMIN.CNNCUT01 Cardinality: 1  CPU Cost: 8,171  IO Cost: 0  Time: 1  								23 	23 0
					27 TABLE ACCESS BY INDEX ROWID TABLE CNADMIN.CNRCLT01 Cardinality: 1  CPU Cost: 17,153  IO Cost: 2  Time: 1  										27 54	27 2
						26 INDEX RANGE SCAN INDEX (UNIQUE) CNADMIN.CNNCLT01 Cardinality: 1  CPU Cost: 8,371  IO Cost: 1  Time: 1  									26 	26 1
				29 INDEX UNIQUE SCAN INDEX (UNIQUE) CNADMIN.CNNLFT01 Cardinality: 1  CPU Cost: 8,171  IO Cost: 0  Time: 1  											29 14	29 0
			32 TABLE ACCESS BY INDEX ROWID TABLE CNADMIN.CNRLAT01 Cardinality: 1  CPU Cost: 15,743  IO Cost: 2  Time: 1  												32 20	32 2
				31 INDEX RANGE SCAN INDEX (UNIQUE) CNADMIN.CNNLAT01 Cardinality: 1  CPU Cost: 8,171  IO Cost: 1  Time: 1  											31 	31 1
		35 TABLE ACCESS BY INDEX ROWID TABLE CNADMIN.CNRACT01 Cardinality: 1  CPU Cost: 15,893  IO Cost: 1  Time: 1  													35 17	35 1
			34 INDEX UNIQUE SCAN INDEX (UNIQUE) CNADMIN.CNNACT01 Cardinality: 1  CPU Cost: 8,171  IO Cost: 0  Time: 1  												34 	34 0

[Updated on: Fri, 04 May 2007 01:51] by Moderator

Report message to a moderator

Re: Help need in tuning this query [message #235110 is a reply to message #235102] Fri, 04 May 2007 01:49 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Unreadable.
FORMAT YOUR POST.

Regards
Michel
Previous Topic: Why ROWID starts with only 1?
Next Topic: How to find Oracle server or Oracle Client
Goto Forum:
  


Current Time: Sat Dec 10 12:57:05 CST 2016

Total time taken to generate the page: 0.06649 seconds