What is the difference between derived table and views?
which one gives better performance?
Answer Posted / pradeep mishra
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 |
Post New Answer View All Answers
What is the difference between datawarehousing and businessintelligence?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
Can we Save (save as) WEBI Doc as DESKI?
When we use aggregate awareness function in designer?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
What is object stores?
any difficulitis have you phase while creating bo reports and how did u solve it
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
how many reports have u created ? explain a few.
How were the reports scheduled and how to resolve unexecuted documents?
Explain what are the steps to be taken to schedule the report?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?