RE: Case for Index Organized table?
- From: "Kerber, Andrew W." <Andrew.Kerber@xxxxxxx>
- To: veeeraman@xxxxxxxxx, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 23 Apr 2007 15:23:47 -0500
I have to ask, how can this possible speed anything up? The only reason
that comes to mind is the developers don't know how to do a function
call on a fixed value, so they want to join through a table? Maybe its
really a developer education issue...
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ram Raman
Sent: Monday, April 23, 2007 2: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.
------------------------------------------------------------------------------
NOTICE: This electronic mail message and any attached files are confidential.
The information is exclusively for the use of the individual or entity intended
as the recipient. If you are not the intended recipient, any use, copying,
printing, reviewing, retention, disclosure, distribution or forwarding of the
message or any attached file is not authorized and is strictly prohibited. If
you have received this electronic mail message in error, please advise the
sender by reply electronic mail immediately and permanently delete the original
transmission, any attachments and any copies of this message from your computer
system. Thank you.
==============================================================================
Other related posts:
