1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

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

Question Posted / mark berlin


SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows paralle..

Answer / 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

Post New Answer

More SQL PLSQL Interview Questions

i declare 4 procedure in package specification but in package body i write only 3 procedure. is it complie??//w

4 Answers   Scope International,

in procedure how to return a value

3 Answers   Wipro,

Is sql microsoft?

0 Answers  

Which table is left in left join?

0 Answers  

What are sql data types?

0 Answers  




What are commit, rollback, and savepoint?

0 Answers  

how to use case expression? : Sql dba

0 Answers  

What is a trigger in pl/sql?

1 Answers  

How to load data with sql*loader?

0 Answers  

What is a temporal data type?

0 Answers  

what is try_catch block in procedure

0 Answers  

What is use of package in pl sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories