RE: Case for Index Organized table?
- From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 23 Apr 2007 16:36:56 -0400
I'd really love to know how this table "speeds up their queries".
Paul Baumgartel
CREDIT SUISSE
Information Technology
Securities Processing Databases Americas, KIYG 1
One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel@xxxxxxxxxxxxxxxxx
www.credit-suisse.com
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Richard J. Goulet
Sent: Monday, April 23, 2007 3:58 PM
To: veeeraman@xxxxxxxxx; oracle-l
Subject: RE: Case for Index Organized table?
Ram,
None other than the shear stupidity of their request.
.....................................................................................................................................
<http://www.kanbay.com/> Kanbay
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.
==============================================================================
Please access the attached hyperlink for an important electronic communications
disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================
Other related posts:
