SQL Tuning, Oracle Server 10g:
Why is the following hint invalid?
SELECT /*+ first_rows parallel(table_name,paral_number)*/
- 1 Answers
- 9525 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is the difference between syntax error and runtime error?
which types of join is used in sql widely? : Sql dba
What are types of joins?
Explain ddl statements in pl/sql?
Explain the difference between 'between' & 'and' operators in sql
How do you update a value in sql?
define sql update statement ? : Sql dba
Where can I learn sql for free?
what is uncommittable transactions? : Transact sql
Is and as keyword in pl sql?
How can we find duplicate records in a table?
How many types of functions are there in sql?
What is the difference between a database and a relational database?
What is the location of pre_defined_functions.
how is myisam table stored? : Sql dba
