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
- 10137 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 |
How show all rows in sql?
Why query optimization is needed?
Which is faster subquery or join?
Which join condition can be specified using on clause?
How to remove duplicate rows from a table?.
What is Difference between StoredProcedure and function?
Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
What is clustered index in sql?
Is postgresql a server?
What are tables and fields?
Can we insert delete data in view?
-
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)
