RE: Case for Index Organized table?
- From: "Richard J. Goulet" <rgoulet@xxxxxxxxxx>
- To: <veeeraman@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 23 Apr 2007 15:58:09 -0400
Ram,
None other than the shear stupidity of their request.
........................................................................
.............................................................
Kanbay <http://www.kanbay.com/>
Richard J. Goulet, Senior Oracle DBA
45 Bartlett ST | Marlborough, MA 01752 USA
Tel: 508.573.1978 | Fax: 508.229.2019 | Cell: 508.742.5795
rgoulet@xxxxxxxxxx <mailto:rgoulet@xxxxxxxxxx>
........................................................................
.............................................................
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ram Raman
Sent: Monday, April 23, 2007 3:12 PM
To: oracle-l
Subject: Case for Index Organized table?
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.
Other related posts:
