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 >> Database Management
  2. Suggest New Category

WHEN YOU FIRE A QUERY IT WILL SLOW WHAT WILL U DO.

Question Posted / muzaffar ali umrani

Answer Posted / muzaffar ali umrani

first check is there any index created in on that table, if yes then arrange your query according to index and check its execution plan and if there is no index on query then create the index.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the functions of database management system?

1022

What is acid property in dbms?

1018

What is the purpose of sql?

994

Are databases stored on servers?

1094

With DTS packaging I can store tables in Excel and convert them back to SQL. But once I copied tables to Excel I want to modify some info. How you do that without editing the Excel file?

2627

Explain the architecture of reporting services?

1029

Describe concurrency control.

1103

What is unique key in dbms?

961

What do you understand by proactive, retroactive and simultaneous update?

1209

Explain the main control blocks available in ims db?

950

What is db context?

974

Mention few case manipulation functions in sql

1039

What is end users in dbms?

1004

What are five types of database models?

944

Explain dml (data manipulation language)?

965