partitioned table on same disk
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: partitioned table on same disk

  1. #1
    Join Date
    Apr 2001
    Posts
    54

    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)

    thanks
    -mcslain

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