What is rule base and cost base optimizer?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain dml and ddl?

554


What is recursive join in sql?

556


What is the difference between unique and primary key constraints?

591


how to fetch common records from two tables? : Sql dba

635


What does data normalization mean?

543






What is the difference between cluster and non-cluster index?

624


What is the maximum number of triggers, you can apply on a single table?

547


How do I filter in sql profiler?

542


What is java sql package?

545


what is a record in a database ? : Sql dba

570


what is unique key constraint? : Sql dba

580


How does an execution block start and end in pl sql?

504


What are the differences between in and exists clause?

575


Difference between truncate, delete and drop commands?

563


How many sql databases can you have on one server?

603