Types of optimization?

Answer Posted / anil kumar abbireddy

1.Cost based Optimization (CBO)
2.Rule Based Optimization (RBO)

Is This Answer Correct ?    19 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is data type in sql?

727


write an sql query to find names of employee start with 'a'? : Sql dba

775


How to write a query to show the details of a student from students table whose

755


What is varchar data type in sql?

715


What is difference between function and trigger?

719






What are local and global Indexes and where they are useful.

1136


What is difference between sql and oracle?

778


Which tcp/ip port does sql server run?

717


Are sql connections encrypted?

747


How many types of relationship are there?

737


Write a query to display the current date in sql?

737


Can we insert data in view?

691


Which one is faster ienumerable or iqueryable?

660


How to run pl/sql statements in sql*plus?

760


Is not equal in sql?

754