Re: Parallel query question

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 30 Oct 1998 19:32:48 GMT
Message-ID: <01be043b$7310e060$0300a8c0@WORKSTATION>

Num_rows is the number of rows produced for a producer, and the number of rows consumed by a consumer.

If the __result__ of your query is a very short report you would hope to see num_rows on the QC being only slightly larger than the number of rows returned by the report.

If the NUM_ROWS listed by the base-line producers sums to about the same number as the number of rows accessed from the database, then the query is probably not a good candidate for parallel execution.

Jonathan Lewis Received on Fri Oct 30 1998 - 13:32:48 CST