What is the difference between derived table and views?
which one gives better performance?
- 2 Answers
- 23864 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
HOW DO YOU RESOLVE MULTIVALUE AND COMPUTATIONERROS?
What are the major problems will occur while migrating to the one version to another version?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
1.How is "Query drill" mode different from standard drill mode?. 2.Under what circumstances are you most likely to choose to use "Query drill" mode instead of standard query mode?. 3.How do you implement the type2 slowly changing dimensions in your project?. 4.what is meant by Junk dimension?. 5.what is meant by Drill across?.
Explain the difference between compatible and incompatible objects?
What is the stored procedure ? What is the need of stored procedure ? How to create a stored procedure Universe?
use scheduler to refresh report.....explain please.....
is there any way to know how long the report executes and how many records will be returned before hitting the "run" option?
how to connect the hyperlink in webi reports?
Can we start CMS server from CMC? Is yes can anyone tell me how plz Thanks in advance?
When a report in Web intelligence is created with ten objects and save the same as PDF the report divides the report into two pages. One page with data for five objects and the other with next five objects? Is there a way to combine these ten columns in a single page view?
what is crystal reports?how to migrate them?
Teradata 
