one is supported in 8i and another in 9i/10g cost base optimizer display t

What is rule base and cost base optimizer?

Question Posted / chandra bhusan prasad

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

Please Help Members By Posting Answers For Below Questions

What are the properties of a transaction?

1118

Explain the update statement in sql

971

What is the advantage of index in sql?

945

Is it possible for a table to have more than one foreign key?

1017

What is the main reason behind using an index?

1002

What is on delete set null?

1071

What is pl sql block in dbms?

991

Does db2 use sql?

923

How many sql statements are used?

1001

Do stored procedures prevent sql injection?

954

Mention what does the hierarchical profiler does?

1066

Which is better join or inner query?

1019

What is the main difference between sql and pl/sql?

1071

What is string data type in sql?

1116

What is procedure explain with program?

996