Re: Parallel Query Instant Gratification?

From: Rniemic <rniemic_at_aol.com>
Date: 29 Jun 1999 19:46:26 GMT
Message-ID: <19990629154626.08643.00006098@ng-fa1.aol.com>

A quick note to add:

If there is a primary key on the table ... the count(*) under cost based will often count the index versus going to scan the table. Of course, this is not true for unique indexes since they allow nulls where primary keys do not. I did write an entire chapter on parallel query in the book ... some Oracle8 changes include allowing parallel hints with DML statements. Also, if you use parallel hints (any hint really), you must hint it in the query that it is contained in ... if you use subqueries ... the hint must be in the subquery ... I guess I'll stop rambling now...

Rich Niemiec
Oracle Performance Tips and Techniques, Oracle Press ISBN: 0078824346 Received on Tue Jun 29 1999 - 14:46:26 CDT