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 oracle pl sql developer?
What is full form of rtm?
Define sql delete statement.
What are %type and %rowtype for?
Why trigger is used in sql?
Does google use sql?
What is meant by user defined function?
What is sql server and ase?
what is an extent ? : Sql dba
how to do backup entire database? : Transact sql
Is merge a dml statement?
What is a left join?
What is a common use of group by in sql?
what is the command line end user interface - mysql? : Sql dba
Explain what is table in a database?