Sign Up Login


  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

What are data types in pl sql?

0 Answers  

What are the different types of database management systems?

0 Answers  

What are the usage of SAVEPOINTS?

5 Answers  

How do you change a value in sql?

0 Answers  

what is definer rights invoke rights?

1 Answers  




what is the use of HASH, LIST partitions?

1 Answers   ITC Infotech,

What is a data manipulation language?

0 Answers  

What is a unique constraint?

0 Answers  

Explain the two type of Cursors ?

8 Answers   Hi Caliber IT,

What is a loop in sql?

0 Answers  

what is difference between delete and truncate commands? : Sql dba

0 Answers  

What is secondary key?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories