Index Organize Tables

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Js
    #1

    Index Organize Tables

    hi all,

    I want to know ..

    I read about IOT's in ORACLE Docs .. But Still I am confused .. when one
    should use IOT tables ..


    Thanks,
    Js
    Tags: None
    • Jim Kennedy
      #2
      Re: Index Organize Tables


      "Js" <js_oracle@yaho o.comwrote in message
      news:ca1f82c7.0 409121438.57a5d f35@posting.goo gle.com...
      hi all,
      >
      I want to know ..
      >
      I read about IOT's in ORACLE Docs .. But Still I am confused .. when
      one
      should use IOT tables ..
      >
      >
      Thanks,
      Js
      Good for lookup tables that are accessed by the primary key.
      Good for colocating information that you are going to look up by most of the
      primary key. The typical example is stock prices where you have ticker
      symbol, date, price.
      Jim


        Comment

        Previous template Next
        Working...