Interested to Buy Any Domain ? << Click Here >> for more details...
What is rule base and cost base optimizer?
- 2 Answers
- 8285 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
Describe sql comments?
how to decrement dates by 1 in mysql? : Sql dba
Can we join 3 tables in sql?
How many sql statements are used? Define them.
How many types of cursors are available in pl/sql?
Can pl sql procedure have a return statement?
How does postgresql compare to "nosql"?
How many types of literals are available in pl sql?
What is the difference between a subquery and a join?
what is a composite primary key ? : Sql dba
What is difference between stored procedures and application procedures?
What is use of trigger?
What are literals in sql server?
What are the key differences between SQL and PL SQL?
What is sqlite format?
