partitioned table on same disk
how great is the benefit of having partitioned tables if the partitions all reside on the same disk? will the benefit be along the lines of using a query that uses an index in order to avoid a full table scan? (compared to a query of a partitioned table that only accesses a few partitions)
I think you would still see a performance improvement since you would be seperating the data. If you were partitioning on date-range by day (for example) then Oracle would only have to scan a days worth of data on one partition.
I would suggest running some tests and tracing the sessions, and then tkprof it to find out what type of improvement you would be looking at. Not everyone has a bunch of filesystems to partition onto. Even if you could have the most recent partition on a different disk/filesystem you would probably see good results.
Click Here to Expand Forum to Full Width