SQL Tuning, Oracle Server 10g:
Why is the following hint invalid?
SELECT /*+ first_rows parallel(table_name,paral_number)*/
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 |
What are the two types of cursors in pl sql?
What is a database trigger ? Name some usages of database trigger ?
What is pivot table in sql?
How to use boolean type in select statement?
What is the difference between SQL table and the PLSQL table?
Which one is the Best approach to put code, among Triggers and Procedures? Explain?
A table has 150 records. How do you retrieve 100th row to 120th row from that table ?
Can we use more than one null value for unique key?
31 Answers A1 Technology, Wipro,
What are sql*plus environment variables?
how view used for security purposes?
Is sql an operating system?
What is a sql statement?