What is rule base and cost base optimizer?
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 date and time intervals? : Sql dba
What is schema in sql example?
Can a foreign key be null?
What are the qualities of 2nf?
How can we implement rollback or commit statement in a trigger?
Can we write ddl statements in functions?
How does postgresql compare to oracle/db2/ms sql server/informix?
Does sap use sql?
What is trigger types in sql?
Does pl/sql support create command?
How many types of literals are available in pl sql?
What is triggering circuit?
What do you think about pl/sql?
What is the use of desc in sql?
Define SQL and state the differences between SQL and other conventional programming Languages?