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
- 24800 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
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
Explain when we use aggregate awareness function in designer?
What we need to discuss with designer before starting the universe designing.
What is package in BO
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Explain what would you consider as your biggest achievement and why?
Difference between b.o 5.1 and 6.1b?
How would you format some text using css to be verdana and bold?
How to open a universe with out using the Designer ??
Explain is there any other repository domains rather than universe, security, document?
Explain the difference between union and group?
how to prepare the documentation in business objects and where to get the requirement?
What is Indexing? how did u implement indexing?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
