Interested to Buy Any Domain ? << Click Here >> for more details...
SQL Tuning, Oracle Server 10g:
Why is the following hint invalid?
SELECT /*+ first_rows parallel(table_name,paral_number)*/
- 1 Answers
- 9964 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 use of index in sql?
What is rownum and rowid?
What is information schema in sql?
Can a commit statement be executed as part of a trigger?
What is multiple columns?
What are the two characteristics of a primary key?
Does mysql_real_escape_string prevent sql injection?
What are the benefits of stored procedures?
what are the advantages of sql ? : Sql dba
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
Why do we use function in pl sql?
What is online transaction processing (oltp)?
What is the need of a partition key?
Is it possible to create startup or shutdown trigger for on-schema?
What is sql clause?
