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 is mutating table error?

0 Answers  

display records from 5 to 9 using rowid or rownum

5 Answers   Agile Software,

what is unique key constraint? : Sql dba

0 Answers  

How do I view a table in sql?

0 Answers  

what is a cursor? : Sql dba

0 Answers  




what are the differences between binary and varbinary? : Sql dba

0 Answers  

What is error ora-12154: tns:could not resolve the connect identifier specified?

0 Answers  

What are the topics in pl sql?

0 Answers  

What is flag in sql?

0 Answers  

What is trigger in sql? Explain

0 Answers  

Temporary table vs Table variable in sql server?

0 Answers   Wipro,

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

0 Answers   Wipro,

For more SQL PLSQL Interview Questions Click Here
Categories