Results 1 to 2 of 2

Thread: Index

  1. #1
    Join Date
    Feb 2003
    Posts
    23

    Question Unanswered: Index

    Hello Readers...

    1) Can anyone explain the concepts and applications of 'Functional Index'.
    2) Is there a site to get the OCP DBA dump question papers with answers.

    Thanks....
    With Regards
    MANI PS

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Index

    Originally posted by manisiva2002
    Hello Readers...

    1) Can anyone explain the concepts and applications of 'Functional Index'.
    2) Is there a site to get the OCP DBA dump question papers with answers.

    Thanks....
    With Regards
    MANI PS
    1) A Function-Based Index (FBI) is just that - an index that is based on a function call. For example:

    CREATE INDEX emp_upper_ename_index ON emp ( UPPER(ename) );

    That index can be used in a query like:

    SELECT * FROM emp
    WHERE UPPER(ename) LIKE 'SMITH%';

    To use FBIs you need to have the QUERY_REWRITE privilege, and the following parameter settings are required:

    QUERY_REWRITE_ENABLED parameter must be set to TRUE
    QUERY_REWRITE_INTEGRITY parameter must be set to TRUSTED.

Posting Permissions

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