SQL Tuning, Oracle Server 10g:
Why is the following hint invalid?
SELECT /*+ first_rows parallel(table_name,paral_number)*/
- 1 Answers
- 9323 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
Why is sql important?
Can pl sql procedure have a return statement?
What is the difference between python and sql?
Explain constraints in sql?
Why query optimization is needed?
who introduced sql?
What is a boolean in sql?
How do I run a pl sql procedure in sql developer?
Is id a reserved word in sql?
What is a pl/sql block?
how to do backup entire database? : Transact sql
what is single byte over head in oracle..?
What is materialized view. What are different methods of refresh?
Is mariadb a nosql database?
What is sql catalog?
