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 |
Does db2 use sql?
What is difference between nchar and nvarchar?
What is a constraint? Tell me about its various levels.
What are the different dml commands in sql?
is it possible to pass an object or table to a procedure as an argument?
what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...
What is a sql select statement?
Can procedure in a package be overloaded?
Is sqlite free?
Can we create a trigger on view?
How do I sort a table in sql?
Can a primary key be a foreign key?
Oracle (3253)
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)