SQL Tuning, Oracle Server 10g:
Why is the following hint invalid?
SELECT /*+ first_rows parallel(table_name,paral_number)*/
- 1 Answers
- 9007 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
How do you determine the current isolation level? : Transact sql
What is varchar used for?
what are the types of join and explain each? : Sql dba
differentiate between float and double. : Sql dba
Explain the types of joins in sql?
Can a table contain multiple foreign key’s?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
What is date functions?
How does sql store data?
What are the commands used in sql?
What is not equal in sql?
What is the difference between sql and isql*plus?
Explain character-manipulation functions?
How to check if a column is nullable before setting to nullable?
When sql appeared?
