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 is the usage of the distinct keyword?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
How do I delete a trigger?
What is the usage of sql functions?
What is trigger and how to use it in sql?
Can we update views in sql?
Explain what is dbms?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
Explain 3 basic parts of a trigger.
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
What is foreign key sql?
What are the query optimization techniques?
How do I run a pl sql procedure in sql developer?
What is nosql example?
What is the most common sql injection tool?