Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    India
    Posts
    87

    Unanswered: Creating Function Based Index

    What type of index is suggested for the following query to be effective.
    The datatype for creation_date is DATE.
    If it function based index. How do we create it?

    select to_char(max(proc_date),'dd Mon, YYYY HH24:MI') creation_date FROM TCS_MIS_EXPENSE_COST

    Thanks

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

    Re: Creating Function Based Index

    No function-based index can help that query: you can't create an FBI on an aggregate function. A simple index on proc_date could be useful.

Posting Permissions

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