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

What is cursor explain with example?

560


What is an exception in PL/SQL? What are the two types of exceptions?

632


Explain the the update statement in sql?

576


How many clustered indexes can be created on a table?

595


How do I audit the sql sent to the server?

528






Can variables be used in sql statements?

555


What is pl sql architecture?

504


Is crud a cuss word?

550


how to convert character strings to numeric values? : Sql dba

578


What is mutating error?

511


What is the process of debugging?

557


Are null values same as that of zero or a blank space?

535


What is data type in sql?

558


what is 'mysqld'? : Sql dba

546


What does truncate mean in sql?

538