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

Why is a primary key important?

977

how many sql ddl commands are supported by 'mysql'? : Sql dba

969

What are the various levels of constraints?

1068

Mention what does the hierarchical profiler does?

1032

what are the advantages and disadvantages of views in a database? : Sql dba

1006

What is a database event trigger?

1098

how to select first 5 records from a table? : Sql dba

930

List the ways to get the count of records in a table?

864

Can pl sql procedure have a return statement?

967

What is the best partition size for windows 10?

958

What are different types of keys?

1030

How to rename a table?

972

Can we use rowid as primary key?

948

What is the difference between sql and isql*plus?

1018

What is sql performance tuning?

873