What is rule base and cost base optimizer?

Question Posted / akshay

2 Answers
8424 Views
Thermotech, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is rule base and cost base optimizer?..

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

What is rule base and cost base optimizer?..

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

Post New Answer

More SQL PLSQL Interview Questions

What is file based approach?

0 Answers

How do I run a sql trace?

0 Answers

Let us suppose we have a table with structure in order empno empname empdesig empcountry and now i want to re-organize the columns of this table to empno empdesig empname empcountry how can i do this with queries ? assume that table contains the data.

3 Answers

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

8 Answers rsystems,

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

4 Answers CGI, IBM,

What are the steps for performance tuning.

0 Answers

What is the left table in sql?

0 Answers

What is foreign key sql?

0 Answers

Which join is default?

0 Answers

What is compute?

0 Answers

What is the difference between between and in condition operators?

0 Answers

what is switch column,colums cost in oracle?

0 Answers Metric Stream,

For more SQL PLSQL Interview Questions Click Here