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 are linked universes? : bo designer

650


What can be different data sources for bo reports? : sap bobi

606


What is the difference between user and versatile?

661


How to do scheduling in desktop intelligence in bo xi r2? : sap bobi

614


What is workgroup mode? : bo designer

656


What is a database connection? : sap bobi

654


Give a hierarchy of business objects? Who will see reports after reports developing is finished? : sap bobi

616


What is an online and offline mode? : sap bobi

674


Where can I find version information for BI platform 4.1 and Crystal Server 2013?

1348


What is custom hierarchies? : sap bobi

702


What are @functions? : bo designer

669


What are the diverse kinds of information suppliers? : sap bobi

608


A project requires the parsing of names into given and family, validating address information, and finding duplicates across several systems. Name the transforms needed and the task they will perform?

599


How the tools under SAP Business objects are categorized?

636


List down all sorts of clients related to business objects? : sap bobi

632