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

In what condition is it good to disable a trigger?

1010

how to include character strings in sql statements? : Sql dba

1071

Does truncate need commit?

942

Is mariadb nosql?

1041

What is left join in sql?

1047

How does one load ebcdic data? : aql loader

1171

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2165

What is sorting in sql?

941

What pl/sql package consists of?

1081

What is a Mapplet?

1120

Can we rollback truncate?

998

Why partition by is used in sql?

1038

How many tables can you join in sql?

957

What is the most important ddl statements in sql are?

997

What is schema in sql?

948