Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    Scottsdale, AZ
    Posts
    106

    Cool Unanswered: Analyzing Nested IOTs

    Should nested IOTs be analyzed?
    "Take Control!
    Make The Choice!
    Accept The Consequences!
    Deal With The Results! "

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    I have heard of a nested table, and I have heard of an IOT (index-organized table). But what is a "nested IOT"?

    An IOT should be analyzed, yes.

  3. #3
    Join Date
    Jan 2004
    Location
    Scottsdale, AZ
    Posts
    106

    Question

    http://download-east.oracle.com/docs...des.htm#446985

    But they aren't clear on the analyzing. A vendor we use, supplies an analyze routine which does not analyze the nested IOTs. They won't give me a straight forward answer for why they don't. So I am trying to determine if they should be, I think they should. Their dba (a former oracle employee) says they don't need to be.

    Thanks.
    "Take Control!
    Make The Choice!
    Accept The Consequences!
    Deal With The Results! "

Posting Permissions

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