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

How to rename a table?

1072


What is a database? Explain

1176


Why do we go for stored procedures?

1123


Define the select into statement.

1108


What is sap sql?

1028


Is the primary key an index?

1076


What does the base_object_type column shows in the user.triggers data dictionary view?

1096


What is clause?

1224


What are the disadvantages of file system?

1354


Is postgresql a server?

1107


How do I audit the sql sent to the server?

1055


How do I find sql profiler?

990


Is sql open source?

1022


Which is better trigger or stored procedure?

1011


Can we insert in sql function?

1139