Because first_rows access and parallel access are mutually exclusive. Pa

SQL Tuning, Oracle Server 10g:
Why is the following hint invalid?

SELECT /*+ first_rows parallel(table_name,paral_number)*/

Question Posted / mark berlin

Answer Posted / mark berlin

Because first_rows access and parallel access are mutually
exclusive.
Parallel always assumes full table scan, first_rows is an
index access

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How do I save a stored procedure?

1069

What is varchar example?

1080

Is not equal in sql?

1062

What is bulk collect in pl sql?

1158

What is the requirement of self-join?

1208

What is the mutating table and constraining table?

1081

What is nvarchar in sql?

978

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

1019

What is sql server and ase?

1070

What programs use sql?

1087

What is trigger in sql?

1156

What is using in sql?

1141

Are subqueries better than joins?

1041

what is normalization? : Sql dba

1137

How many sql statements are used?

1072