Parallel Query
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Parallel Query

  1. #1
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356

    Question

    Hi! All
    Does effedtive Parallel Query processing need the base tables to be analyzed? or can parallel query be used with rule based optimizer?
    Thanx
    There Nothing You cannot Do, The problem is HOW.

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    PQ will be effective only on multiple CPU machine. It is not necessary to analyze the table for employing PQ.

    PQ can be used with RBO as well as with CBO.

  3. #3
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356
    Thanx a lot
    There Nothing You cannot Do, The problem is HOW.

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