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 / vaibhavi_dixit

Also check that the tables does not have more NULL values,
which also reduces the performance.

VD

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does inner join return duplicate rows?

967


Explain mutating table error.

1187


Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

975


Define concurrency control. : Transact sql

1172


What are functions in sql?

946


column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7308


Does asenumerable execute the query?

1035


What is tuple in sql?

1058


How delete all records from table in sql?

973


Is like operator in sql case sensitive?

1012


Why is %isopen always false for an implicit cursor?

1097


What is the difference between cross join and natural join?

1013


What is sqlcontext?

1070


What does select count (*) mean in sql?

1011


What is the difference between rename and alias?

1333