What is rule base and cost base optimizer?
- 2 Answers
- 7762 Views
- Thermotech, I also Faced
- E-Mail Answers
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 normalization in sql?
How do you add a column to a table?
What is crud diagram?
Explain exception handling in pl/sql?
Can procedure in package be overloaded?
What is embedded sql with example?
What is a natural join?
What is sql performance tuning?
What are string functions in sql?
what are different types of keys in sql?
How does join work in sql?
Can we commit in trigger?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
