In article <5366fb41.0403240841.7d85d038_at_posting.google.com>, simmons_mark_at_yahoo.com (Mark) wrote:
>Colin,
>/* works good for iot */
>SELECT * FROM TABLE ID=100 AND DATESTAMP BETWEEN SYSDATE AND
>SYSDATE+30;
>
>/* works good for heap */
>SELECT * FROM TABLE ID=100 AND DATESTAMP=SYSDATE AND HOUR=4;
>
>Testing always reveals the truth.
>
>Others here may have diffent input, but that's what I've seen.
>
>Again, I'd check with your DBA before pushing for this because he/she
>may have information as to why an IOT will not work well in your
>scenario.
>
found out that he has never used IOT and doesn't know how or why we would use
them. He has used a heap/index format before and they works fine.
Received on Wed Mar 24 2004 - 12:55:06 CST
