Interested to Buy Any Domain ? << Click Here >> for more details...
Types of optimization?
- 6 Answers
- 15503 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 |
in procedure how to return a value
What is a unique constraint?
What is sql engine in oracle?
What is case function?
What are pl/sql cursors?
Why coalesce is used in sql?
What is pl/sql table? Why it is used?
what is the difference between where clause and having clause? : Sql dba
Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.
What is the primary use of normalization?
what are wild cards used in database for pattern matching ? : Sql dba
How can we make an if statement within a select statement?
-
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)
