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

How to disable a trigger name update_salary?

0 Answers  

What are the events on which a database trigger can be based?

0 Answers  

how to fetch alternate records from a table? : Sql dba

0 Answers  

Explain the difference between rename and alias?

0 Answers  

what is External tables? explain with examples

2 Answers   TCS,




What port does sql server use?

0 Answers  

what is log shipping? : Sql dba

0 Answers  

What is integrity in sql?

0 Answers  

Can we create foreign key without primary key?

0 Answers  

Can a trigger call a stored procedure?

0 Answers  

What is the purpose of design view?

0 Answers  

How many triggers can be implemented for a table?

3 Answers   HSBC,

For more SQL PLSQL Interview Questions Click Here
Categories