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

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

960

What will you get by the cursor attribute sql%notfound?

1080

Why should I use postgresql?

1022

What is the command used to fetch the first 5 characters of a string?

1209

What are the various levels of constraints?

1126

What are the rules to be applied to nulls whilst doing comparisons?

1323

how to enter numeric values as hex numbers? : Sql dba

1068

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

1003

What is composite primary key in sql?

999

How does pl sql work?

965

define data blocks ? : Sql dba

1000

What is the purpose of cursors in pl/sql?

1138

What are the most important characteristics of pl/sql?

1161

what is innodb? : Sql dba

1110

how would you enter characters as hex numbers? : Sql dba

986