Interested to Buy Any Domain ? << Click Here >> for more details...
What is rule base and cost base optimizer?
- 2 Answers
- 8415 Views
- Thermotech, I also Faced
- E-Mail Answers
Answer Posted / chandra shekher
Rule based optimiser will optimise the query based on the
rules.
Cost based optimiser will optimise the query based on the
statistics available for the table.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
what are the security recommendations while using mysql? : Sql dba
What is the difference between sql and isql*plus?
Why is sql*loader direct path so fast?
Do foreign keys improve performance?
Can a foreign key be a duplicate?
What are different functions in sql?
What is union, minus and interact commands?
Can we use ddl statements in stored procedure sql server?
Explain the working of foreign key?
What is a boolean in sql?
How many parts of a pl sql block are optional?
What is the usage of sql functions?
What is pl sql in dbms?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
What is the difference between unique and primary key constraints?
