Interested to Buy Any Domain ? << Click Here >> for more details...
What is rule base and cost base optimizer?
- 2 Answers
- 8405 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 is write ahead logging in sql server?
Why indexing is needed?
How can I delete duplicate rows?
What is a null value?
Can sql function call stored procedure?
what is a constraint? Tell me about its various levels. : Sql dba
What do you mean by rowid?
What are the topics in pl sql?
How many subqueries can be nested in a statement?
What is a memo field?
What is the difference between a database and a relational database?
what is data manipulation language? : Sql dba
Can we use pl sql in mysql?
Which are the different character-manipulation functions in sql?
Why do we use subquery?
