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

Thread: Parallel Query

  1. 06-29-2001, 03:23 AM #1
    sudip's Avatar
    sudip
    sudip is offline Senior Member
    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.
    Reply With Quote Reply With Quote
  2. 06-29-2001, 09:37 AM #2
    tamilselvan
    tamilselvan is offline Senior Advisor
    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.
    Reply With Quote Reply With Quote
  3. 07-01-2001, 11:08 AM #3
    sudip's Avatar
    sudip
    sudip is offline Senior Member
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356
    Thanx a lot
    There Nothing You cannot Do, The problem is HOW.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width