home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 1,737 of 2,288   
   Jim Kennedy to js_oracle@yahoo.com   
   Re: Index Organize Tables   
   13 Sep 04 01:29:01   
   
   From: kennedy-downwithspammersfamily@attbi.net   
      
   "Js"  wrote in message   
   news:ca1f82c7.0409121438.57a5df35@posting.google.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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca