Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between derived table and views?
which one gives better performance?
- 2 Answers
- 24947 Views
- TCS, I also Faced
- E-Mail Answers
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
Explain how to execute the plsql procedure from the report by clicking with mouse?
Can anybody tell me what are the tuning problems?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
how to prepare the documentation in business objects and where to get the requirement?
Which versions are used in the bo dashboard work?
When to use local filter and when to use global filter?
how to create reports on screech?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
what are the tables used in health care domain project and columns used in report?
Give some information on report bursting?
U r project in which stage in implementation?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
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?
