| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: When should I reorg?
What's significantly less?
Why do you require to read the whole table every time?
Have you considered using materialized views for summaries (if you scan the whole table for summaries)?
Have you considered selecting subsets of data (e.g. utilizing rownum)? (if you require looking through the whole table in parts).
.......
We use Oracle 8.1.7.4 and 9.2.0.6/7 on Solaris 2.7 and RH4
remove NSPAM to email
Received on Tue Aug 30 2005 - 14:02:38 CDT
 |
 |