Types of optimization?
- 6 Answers
- 14293 Views
- Microsoft, I also Faced
- E-Mail Answers
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 the difference between delete and truncate statement in sql?
Where is sql database stored?
Show code of a cursor for loop.
Explian rowid, rownum?
What are sql data types?
How to create a view on a table which does not exists
How do you display "13th of November, 17 days left for month end" without hardcoding the date.
What is error ora-12154: tns:could not resolve the connect identifier specified?
What is Difference Between Unique and Primary Key Constraints?
What is the difference between instead of trigger and after trigger?
How do you declare a constant?
What are the attributes of SQL*PLUS ?
2 Answers Dream Careers, Oracle,
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
