HI, can anybody explain me how performence will decrease if we create objects

HI, can anybody explain me how performence will decrease if
we create objects using derived tables ?

Question Posted / vinodkrishnamsetty

2 Answers
5165 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

HI, can anybody explain me how performence will decrease if we create objects using derived tables..

Answer / manoj

Derived Tables decrease the performance because even if you
include one single object from this table the entire query
from the table is executed .

You can see this in the sql Query panel.

hence i would avoid using any derived tables unless
mandatory

Is This Answer Correct ?

5 Yes

0 No

HI, can anybody explain me how performence will decrease if we create objects using derived tables..

Answer / ashok

by using derived table we can improve the query performance
because that is not created in database it can be designed
at universe designer only.

Is This Answer Correct ?

2 Yes

2 No

Post New Answer

More Business Objects Interview Questions

How to view Public folder in Infoview for the Non-admin user? (normal user) What is the diff of working DEKI,WEBI in Infoview, and working as Individual start->Business Objects-> Deskto Intelligence, Web Intelligence.

1 Answers Cap Gemini, TCS,

i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

0 Answers Patni,

Can we link the oracle and excel universess?

1 Answers

What is the most complex report you have developed. Explain and how did you overcome??? Please give some examples

2 Answers NTT Data,

Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

0 Answers

What is the difference b/w the simple Universe and Complex Universe?

2 Answers

Explain about a task that really tested your analytical abilities?