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
- 10218 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 |
Can we create foreign key without primary key?
I have 2 Databases. How can create a table in particular database? How can i know the list of tables presented each database?( in oracle 10g)
What is minus?
How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?
A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to create hierarchy.
Can we create table inside stored procedure?
How do I use google cloud in sql?
Can we create table in function?
What are the parameter modes supported by pl/sql?
What is the maximum size of sqlite database?
How can a pl sql block be executed?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
-
Oracle (3253) - 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)
