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
- 9968 Views
- Accenture, I also Faced
- E-Mail Answers
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 |
Is primary key clustered index?
Delete the emps whose salaries are lowest sals of their own dept.
How would you convert date into julian date format?
how can we know the count/number of elements of an array? : Sql dba
What is nvarchar max in sql?
what is 'mysqlcheck'? : Sql dba
What are Nested Tables? How will u delete 5 rows from Nested Tables
What are synonyms in sql?
What are the types of optimization?
I want to create synonym for table emp but in my pc it is giving insufficient previliges.I am using user scott.Please suggest me.
How to find the count of letter "L" in HELLO
How many triggers can be implemented for a table?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
