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
How to prepare for oracle pl sql certification?
What is dynamic query?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
Why we use cross join?
Is microsoft sql free?
explain the difference between bool, tinyint and bit. : Sql dba
What is structural independence and why is it important?
How does one load ebcdic data? : aql loader
Give the order of sql select?
Why having clause is used in sql?
what are the limitations of identity column? : Transact sql
Can delete statement be rollbacked?
Mention what pl/sql package consists of?
What is a temporal table?
What is pl sql script?