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 does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
Is grant a ddl statement?
What is pl sql collection?
how to rename an existing column in a table? : Sql dba
Why do we need cursor in pl sql?
What is the difference between in and between in sql?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
What is sql keyword?
How sql query is executed?
What does data normalization mean?
Define SQL and state the differences between SQL and other conventional programming Languages?
What is the difference between count 1 and count (*) in a sql query?
What is pl sql script?
How many indexes can be created on a table in sql?
Why trigger is used in sql?