Re: Case for Index Organized table?

Ram,

    I just can't wait for the time when they archive their data and want to keep 5 years online.

Other ideas to speed up their queries: create a table to hold every possible number of every possible street they find in the addresses they manage. Create a table to hold every cent so as to cover every price they may have to deal with. Do it in every possible currency you may encounter, of course. And for character strings, it might just be helpful to have another single-column table to hold every possible combination of characters. Just in case.

Never, ever believe developers without innocently asking "may I have a look?" first.

Stéphane Faroult

Ram Raman wrote:
> 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