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
24373 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

How to execute the plsql procedure from the report by clicking with mouse?

0 Answers

how get the grand total in master-detail report?

0 Answers Patni,

WHAT DOES SQL TAB CONTAIN?

1 Answers Polaris,

in BO module, you forgot all password even all user in business object, designer, supervisor, gen.supervisor everythicg, how to you recover your datas?

1 Answers iFlex,

How to Avoid the overlaping the blocks in WEBI.

3 Answers

What is Indexing? how did u implement indexing?

0 Answers TCS,

what are the all possible reasons of getting partial result on a webi report?

3 Answers L&T,

What is the sheduling the report? What is the need of sheduling the report?

1 Answers Wipro,

what is incompactabulity error in sap bo

2 Answers

What is the difference b/w breaks and sections

2 Answers IBM,

What is user docs and how to use this option in bo?

1 Answers Bank of Baroda,

Iam having an report there four cloums and n number of rows if i click ang one cell the report want to go to another report page which gives the detail of the cell which i click pls help me with example

1 Answers IBM,

For more Business Objects Interview Questions Click Here