DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2001

    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)


  2. #2
    Join Date
    Oct 2002
    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.
    - Cookies

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.