Types of optimization?
Answers were Sorted based on User's Feedback
Answer / anil kumar abbireddy
1.Cost based Optimization (CBO)
2.Rule Based Optimization (RBO)
| Is This Answer Correct ? | 19 Yes | 4 No |
Answer / sohail
Two types of optimization.
1.logical optimization
2.physical optimization.
| Is This Answer Correct ? | 8 Yes | 4 No |
Answer / sanket mishra
local optimization
global optimization
with respect to intermidiate code optimizer in Compiler
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / parameswara reddy.challa
logical optimization
physical optimization
| Is This Answer Correct ? | 4 Yes | 3 No |
Answer / rajesh
full optimization
on-page optimization
off-page optimization
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / esther eleonu
Amount optimum
symmetrical optimum
variant optimum
| Is This Answer Correct ? | 0 Yes | 0 No |
Why do we create stored procedures & functions in pl/sql and how are they different?
What are the usage of SAVEPOINTS?
Can we use the cursor's to create the collection in PL/SQL?
Why join is faster than subquery?
How do you remove duplicate records from a table?
What is rtm in testing?
What is synonyms?
what is sql in mysql? : Sql dba
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
What is the difference between truncate and drop statements?
Why should I use postgresql?
Can you have more than one trigger on a table?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)