Longer time for Hash Partitioned Table FullScan
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Longer time for Hash Partitioned Table FullScan

  1. #1
    Join Date
    Jan 2002
    Posts
    59
    I have a Hash Partitioned table accross 8 tablespaces on different drives.
    When do a
    select * from where rownum < 100

    it takes 4 Secs.
    To cross check i created another NOnPartitioned table with a Select from the above Hash_Part_Table.

    and fired the same select querry and got the resultset withing 0 MSecs.

    **PleaseNote : Both Tables are without any Parallel Degree specifications, and the test is being done at Idle time.

    Does any body help me to understand why this happened.

    Thanx in Adv
    Sanjay

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    You would have to do a trace with it, but I would bet the query against the partitioned table is pulling more blocks back from disk than the normal table.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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