Re: Prevent FTS

From: chao_ping <chao_ping_at_vip.163.com>
Date: Mon, 06 Jan 2003 16:53:38 -0800
Message-ID: <F001.00528171.20030106165338@fatcity.com>

manoj.gurnani,

	hI, It seems that you do not need this clause:
	and y.col_1 = z.col_1 	
	and y.col_2 = z.col_2
	right?
	Is your table z rather small? If your table have different size or your optimizer mode is different, oracle will show different plan. It is not necessary that index scan is better than fts.It depends . Test the result and see it:)	

Regards
zhu chao
msn:chao_ping_at_163.com
www.happyit.net
www.cnoug.org(China Oracle User Group)

• 2003-01-06 09:39:00 ,you wrote£º======= I've 3 tables table x,y,z pk of x is (col_1,col_2),pk of y is (col_1,col_2,col_4,col_5),pk of z is
  (col_1,col_2)
  

where clause is :

where x.col_1 = y.col_1

and x.col_2 = y.col_2
and x.col_1 = z.col_1
and x.col_2 = z.col_2
and y.col_1 = z.col_1
and y.col_2 = z.col_2

and x.col_3 in ('val1','val2','val3')
and.....
.

Explain plan shows that there is a FTS of table z . what can be the reason for this and how to prevent this.

Thanks
Manoj

• = = = = = = = = = = = = = = = = = = =

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: chao_ping
  INET: chao_ping_at_vip.163.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Mon Jan 06 2003 - 18:53:38 CST