Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2008
    Posts
    3

    Unanswered: inner table index,outer table index

    Hi,

    I was searching the net to find some info about it(in the title), but I found not much(neither in my language or in English). I would be really happy if somebody could explain it to me. The questions really are choosing index for the inner table in join and choosing index for the outer table in join.

    Thank You
    Last edited by oll3i; 09-08-08 at 17:19.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Perhaps if you posted the homework question in full, we might have a clue what it is lookng for. There is no such thing as an "inner (or outer) table index" in Oracle.

  3. #3
    Join Date
    Sep 2008
    Posts
    3
    The questions really are choosing index for the inner table in join and choosing index for the outer table in join.


    thank You

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    The optimiser chooses the indexes from those available on the tables. If you are joining on the "outer" table by column X then it may choose to use an index defined on column X. For the "inner" table (which I assume means driving table?), it may use an index suitable for filtering conditions, e.g. if you specified "WHERE inner.col1 = 123" then it may use an index on col1.

  5. #5
    Join Date
    Sep 2008
    Posts
    3
    thank You a lot a lot a lot

Posting Permissions

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