What is the difference between derived table and views? which one gives better

What is the difference between derived table and views?
which one gives better performance?

Question Posted / sasi kanth

2 Answers
24797 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is the difference between derived table and views? which one gives better performance?..

Always View is better than Derived Tabels because it
fetches the Data Directly through the Database So as per
the Performance related it's too good.
But,When we want to use @Function (@variable,@prompt) in
your Query that time it's only possible in Derived
Table,not in the VIEWS.

Is This Answer Correct ?

21 Yes

0 No

What is the difference between derived table and views? which one gives better performance?..

Answer / prasanna.ramesh1

a derived table is dynamic,virtual table that you create
within universe structure.it consists of set of sql
statements that you create in designer and you can use it as
a logical table to create objects.

in the derived table sql set,you can put a select statement
in place of table name in the from clause.sql set can also
contain embeded prompts and you can create joins between
embeded physical tables ,just as you can with other tables.

derived tables can be used in place of database
views,aggregate tables,lookup tables.

by using derived table we are processing load from the
report server to the database.

views are also virtual tables which are created in database
level and can make use in universe.but we can not create
them in universe structure.

Is This Answer Correct ?

11 Yes

6 No

Post New Answer

More Business Objects Interview Questions

could you please give me the diagram of BO 6.5 Architecture or explain about the tires?

6 Answers PCS, Tech Mahindra,

Hi frns, In the report level i have dragged objects in the query panel. If i check the sql query it is displaying 2 separate queries. What will be the possibilities for this?

2 Answers Accenture,

how to schedule a report for even number dates?

2 Answers HCL,

any of the person working on encyclopedia? give the explanation briefly?

1 Answers TCS,

what is crosstab reporting,slice and dise and drill mode??

3 Answers

i want to creat 2way drilling using hyrarchies and hyperlinks...can anyone please help me

0 Answers

How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

0 Answers

Approximatly how many enduser can use the each bo project?