What is rule base and cost base optimizer?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / chandra bhusan prasad
one is supported in 8i and another in 9i/10g
cost base optimizer display the cost attributes of query
and it is easier.
| Is This Answer Correct ? | 1 Yes | 3 No |
What is the trigger in sql?
How do I run a sql query?
What is offset and limit in sql?
What is the usage of NVL?
7 Answers Infosys, Micro Infotek,
What is recursive join in sql?
What is difference between sql function and stored procedure?
What are the different types of constraints?
What is db journal file?
explain access control lists. : Sql dba
Explain mutating table error.
Can we group by two columns in sql?
What are inner outer left and right joins in sql?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)