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

Give two examples of how the data cleanse transform can enhance (append) data?

844


Explain users associated with business objects?

781


Define chasm trap?

786


How to access one derived table from another? : sap bobi

770


What is the difference between lookup (), lookup_ext () and lookup_seq ()?

2339


What are slice and dice? : sap bobi

928


How do you save a business objects document which can be accessed by all users in workgroup mode? : sap bobi

784


Explain how can custom hierarchies be created?

897


Explain modes associated with designer and business objects?

764


How many modes are there in bo & designer? : sap bobi

820


What are the steps included in data integration process?

811


Define WEBI?

896


What are the various data sources available?

921


Explain context in the universe?

800


What type of connections designer provides? : bo designer

743