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

when All datafiles related to a Tablespace are removed ?

0 Answers  


What is 1nf in database?

0 Answers  


What are the features of openedge features?

0 Answers  


What is the maximum size of the page ?

2 Answers  


How to prevent firebird.log file from filling up the disk partition?

0 Answers  


Write a query to remove duplicate rows from a table?

0 Answers  


What is unique key example?

0 Answers  


Explain ERASE packaged procedure ?

1 Answers  


which is the best institute to learn Oracle DBA 10g/11g, please advise, someone?

2 Answers  


How to change database dialect?

0 Answers  


What you mean by Object Relational DBMS?

0 Answers   Infosys,


What is drivermanager getconnection?

0 Answers  


Categories