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


user says the db performance is slow or yesterday the query runned 1min and today its taking 30 min. how to trouble shot or were to start with?



user says the db performance is slow or yesterday the query runned 1min and today its taking 30 min...

Answer / basanti

1. Check the volume of data.
2. check whether index need to be rebuild or not.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Database Management Interview Questions

What are vdl and sdl?

0 Answers  


what are the differences between network and hierarchical database model?

0 Answers  


What are the types of distributed database?

0 Answers  


Can we save file in database?

0 Answers  


Explain the terms database and dbms?

0 Answers  


What is hashing in dbms?

0 Answers  


Is it possible to Disable the Parameter form while running the report ?

1 Answers  


What do you mean by query evaluation engine?

0 Answers  


What are Stored Procedures and When would we Use Them?

1 Answers  


what Kind of COMMENT statements placed within SQL statements ?

2 Answers  


What is Archived Redo Log ?

3 Answers  


What is dbms and its functions?

0 Answers  


Categories