DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Function Based Index

  1. 12-04-2002, 07:19 AM #1
    anuj
    anuj is offline Junior Member
    Join Date
    Aug 2001
    Posts
    56

    Function Based Index

    Hi

    Can any body tll me. which one is most effect on rule based and cost based optimization. if the data is in bulk.

    can be find statistics on function based index on cost based optimizer.
    Anuj
    India
    Reply With Quote Reply With Quote
  2. 12-04-2002, 07:32 AM #2
    eeswar
    eeswar is offline Junior Member
    Join Date
    Oct 2002
    Location
    Singapore
    Posts
    16
    check this out...

    http://www.dbasupport.com/oracle/ora8/fbi.shtml
    Never Ever Give Up!
    Reply With Quote Reply With Quote
  3. 12-04-2002, 07:32 AM #3
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well I think if you use RBO you cannot use function based index
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width