partitioned table on same disk

[mcslain]

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)

thanks
-mcslain

[Cookies]

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.