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

I have two rows in my database, one is emp I'd and
Another one is salary and I have only 50 records in that table.when I retrieving the data. It's taking the time max 4 minutes. But the client requirement is the data should retrive below 2 min. How can you resolve? Kindly suggest this one.

Answer Posted / aishwary

By creating index on empid column

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is custom hierarchies? : sap bobi

924


Define the two distinctive methodologies of executing complete mindfulness. Which is better as far as execution? : sap bobi

817


What is a master/detail report?

910


What is strategies?

843


How to add a description to the list of values?

1514


What is a secured association? : sap bobi

895


What are the classes? : sap bobi

916


Can you explain data mining?

818


List out the different products related to Business Objects?

844


What is solution for improving performance?

862


Explain methods related with multidimensional analysis that is inside business objects?

912


What are the contrasts between personal, secured and shared associations? : sap bobi

861


Explain the arrangement of sap business customer apparatuses? : sap bobi

881


Define Designer?

949


What is Drill by?

893