What is rule base and cost base optimizer?
- 2 Answers
- 7768 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
Is sql a scripting language?
Does view contain data?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
Is it possible to sort a column using a column alias?
What is the most restrictive isolation level? : Transact sql
How do you copy a table in sql?
What operators deal with null?
how to check myisam tables for errors? : Sql dba
How do I start sql from command line?
What is the difference between a database and a relational database?
What is sql engine in oracle?
How delete a row in sql?
Define overloaded procedure?
describe transaction-safe table types in mysql : sql dba
