Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Case for Index Organized table?

Case for Index Organized table?

From: Ram Raman <veeeraman_at_gmail.com>
Date: Mon, 23 Apr 2007 14:11:53 -0500
Message-ID: <effc058d0704231211u7c5c6a63rd299b978774b61ea@mail.gmail.com>


Hi all,

I got a requirement from the developers to build a new table which has a column that will hold every second of every business day. That is the only column in the table. The table will be truncated everyday and loaded with the subsequent day's time. The developers told me that this table speeds up their queries, I also talked about using other ways but they said that they tested a few ways and found this one the best. They also want an index on that table. I am thinking of creating an index organized table for this purpose. Does anyone foresee any problem in this approach.

Ram.

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 23 2007 - 14:11:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US