Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

How do you optimize SQL queries ?

Question Posted / kumar srinivasalu

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

Write a sql query to get the third highest salary of an employee from employee_table?

1026

What is bind reference and how can it be created?

965

How to process query result in pl/sql?

1056

What is coalesce in sql?

970

What is cte sql?

924

How do you go back in sql?

939

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

941

what is timestamp in mysql? : Sql dba

997

What is the need of a partition key?

940

Does sql use python?

972

What is the current version of sql?

970

Is and as keyword in pl sql?

897

List out the acid properties and explain?

902

what are myisam tables? : Sql dba

943

What is the least restrictive isolation level? : Transact sql

991