Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Function based indexes
Sergey,
I did a quick test which indicates that no special path is mentioned when using a FBI, instead the execution plan will show that an index is being used, which it would not do if a FBI had not been set up. The example below shows what I mean
HTH John
SQL> create index john_idx1 on john(spid_type); SQL> select spid_type from john where upper(substr(spid_type,2,1)) = 'Y' SQL> /
Execution Plan
SQL> select spid_type from john where upper(substr(spid_type,2,1)) = 'Y'; SPID_TYPE
Execution Plan
*************************FBI in use****************************tes=1344)
*************************FBI in use****************************ard=96)
-----Original Message-----
Sent: 26 February 2002 20:51
To: Multiple recipients of list ORACLE-L
Hi, everyone,
This may seem very simple to you, but what's the best way to see if a fresh FBI (sorry!) is used during the execution? Are they reported in the same manner to the SQL trace as other ones?
Regards,
Sergey
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hallas John INET: John.Hallas_at_btcellnet.net Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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-LReceived on Wed Feb 27 2002 - 02:53:18 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
![]() |
![]() |