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...

What is the first action to perform a query?
Suppose I have four tables and five joins and my query is
getting slow day by day.

Answer Posted / avi007

check the how many indexes created on join column of
tables, check the join which has been done on common column
of both tables.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sql not null constraint?

1096


What are the packages in pl sql?

1067


What does select top 1 do in sql?

1142


Is microsoft sql free?

1142


What does where 1/2 mean in sql?

1145


Are left and right joins the same?

1161


What is an example of translating a date into julian format?

1206


Why do we create views in sql?

1220


What are predefined functions in sql?

1109


What is nvarchar max in sql?

1076


How to run sql functions in pl/sql?

1124


how many triggers are allowed in mysql table? : Sql dba

1107


what is a trigger in mysql? Define different types of trigger. : Sql dba

1121


How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1250


What is serial sql?

1043