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
-----Original Message-----
From: Babich , Sergey [mailto:[EMAIL PROTECTED]] Sent: 26 February 2002 20:51 To: Multiple recipients of list ORACLE-L Subject: Function based indexes 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
|
- Function based indexes Babich , Sergey
- function based indexes Hallas John
- function based indexes Harvinder Singh
- RE: function based indexes DENNIS WILLIAMS
- Function based indexes Imma C. Rocco
- Re: Function based indexes Jared Still
- RE: Function based indexes Sandeep Kurliye