Results 1 to 2 of 2

Thread: Optimal index

  1. #1
    Join Date
    Feb 2004
    Posts
    1

    Unanswered: Optimal index

    Hi,
    I know I should search first for something similar in the forum but I have no time, so I ask you about a optimal way to define one index for the following SQL statement:

    SELECT * FROM numbers
    WHERE 100 BETWEEN nb_min AND nb_max;

    Thx.

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

    Re: Optimal index

    Oddly enough, this very topic was being discussed on Ask Tom yesterday! The only difference was that it was a DATE value rather than a NUMBER value:

    http://asktom.oracle.com/pls/ask/f?p...:4921012347969

    Search for "indexing" (near the bottom).

Posting Permissions

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