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

Write a sql query to get the third highest salary of an employee from employee_table?

1061

Is left join same as join?

975

how to create a table index in mysql? : Sql dba

1039

Are subqueries faster than joins?

999

What is cursor status?

1178

what is text? : Sql dba

1060

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1080

Explain alias in sql?

1029

What is the usage of the distinct keyword?

1202

Which are the different case manipulation functions in sql?

1009

Explain how to use transactions efficiently : transact sql

957

Explain select statements in sql?

1046

what is msql? : Sql dba

971

What is sql rowcount?

990

What is the purpose of a sql?

964