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 |
what is cursor procedure
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
How do I view a sql trace file?
Explain the significance of the & and && operators in pl sql.
What is diff between bulk collect and forall
how can we know the number of days between two given dates using mysql? : Sql dba
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?
What is date functions?
How One can easily select all even, odd, or Nth rows from a table using SQL queries?
What are the advantages of stored procedure?
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)