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

How do you optimize SQL queries ?

Question Posted / kumar srinivasalu

6 Answers
35594 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

Explain what is a column in a table?

1045

What is example of database?

986

Where is all the data on the internet stored?

949

What is procedure and function in sql?

930

Define join and name different types of joins?

960

What is optimistic concurrency control? : Transact sql

944

Do we need commit after truncate?

1034

How many postgresql users are there, worldwide?

994

What are sql*plus environment variables?

1032

How to create your own reports in sql developer?

976

How do I install microsoft sql?

984

How to read/write files from pl/sql?

994

how can we repair a mysql table? : Sql dba

916

Why do we use procedures in pl sql?

964

How do we accept inputs from user during runtime?

992