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

What is an ndf file?

985

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7303

What is the difference between inner join and left join?

976

How delete all data from all tables in sql?

939

Are stored procedures faster than queries?

940

Is sql similar to python?

965

What is the use of <> sql?

967

What is sql in oracle?

1051

How do I run a program in pl sql?

994

What is the size of partition table?

1041

How to change sql*plus system settings?

1046

What is record variable?

971

What is a temporal data type?

1039

What is difference between db2 and sql?

992

What is the difference between delete, truncate and drop command?

1131