BY USING HINTS, HASH JOINS, PARTITION TABLES AND INDEXS, RESERVE KEY IN

How do you optimize SQL queries ?

Question Posted / kumar srinivasalu

6 Answers
35804 Views
CarrizalSoft Technologies, Infosys, Oracle, I also Faced
E-Mail Answers

Answer Posted / kumar srinivasalu

BY USING HINTS,
HASH JOINS,
PARTITION TABLES AND INDEXS,
RESERVE KEY INDEX,
BIT MAP INDEX,
COST BASED OPTIMIZATION,
Nested loops,full table scans,query rewrite with
materialisation views
BASED ON THIS WE OPTIMIZE THE SQL QUERIES.

Is This Answer Correct ?

26 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What does seeding a database mean?

948

What is pl sql in oracle?

1037

define data blocks ? : Sql dba

971

Write a query to display the current date in sql?

1013

What are operators available in sql?

1035

What are the advantages of sql?

1049

How does one load ebcdic data? : aql loader

1157

Is sql a dbms?

989

What is sqlca in powerbuilder?

1000

What is varchar example?

1022

What are the disadvantages of not performing database normalization?

1153

What is the difference between cluster and non-cluster index?

1099

what is a constraint? : Sql dba

1134

How long will it take to learn pl sql?

932

Which command is used to delete a trigger?

1320