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

Which command is used to call a stored procedure?

0 Answers  

what is transaction? : Sql dba

0 Answers  

Is sql better than access?

0 Answers  

How does a covering index work?

0 Answers  

Write a sql query to convert all character to uppercase after hypen.

0 Answers  




What is denormalization in a database?

0 Answers  

What is pl/sql tables?

7 Answers   TCS,

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

0 Answers  

What is crud diagram?

0 Answers  

Why procedure is used in sql?

0 Answers  

Which are the most commonly used sql joins?

1 Answers  

What is data definition language?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories