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
If you want to find immediate answers to business questions, which tool you would go with?
Define personal connection? : sap bobi
What is data cleanse?
What are linking of universes and how many levels of linking is possible? : bo designer
What are slowly changing dimensions, confirm dimensions? : sap bobi
What are the data integrator transforms?
Define Designer?
What is a setting in the universe and how they are made? : sap bobi
What are the advantages of using business objects?
What is aggregate awareness and steps involved in it? : sap bobi
Define WEBI?
What is an online and offline mode? : sap bobi
What is Shared connection?
How many modes are there in bo & designer? : sap bobi
Define the two distinctive methodologies of executing complete mindfulness. Which is better as far as execution? : sap bobi