Results 1 to 2 of 2

Thread: Order of predicate evaluation in queries at IN subclause under Where Clause

  1. #1
    Join Date
    Nov 2006
    Posts
    1

    Question Order of predicate evaluation in queries at IN subclause under Where Clause

    Any one can suggest me what will be the order of execution of the values for update query under WHERE Clause IN
    e.g.
    update <tablename> set <columname> where <columname> IN(value1, value2, value3, value7, value5, value4)

    Will oracle smart enough to sort these values inside the IN Clause in natural order

  2. #2
    Join Date
    Nov 2006
    Posts
    2
    There is no sense in ordering the keys before update, as it is physically spread all over the table.

    But actually oracle 10 sorts rowid's fetched from indexes before fetching data blocks in order to minimize table access.

Posting Permissions

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