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
- 25047 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
How would you format some text using css to be verdana and bold?
Explain which versions are used in the bo dashboard work?
how get the grand total in master-detail report?
Explain about a task that really tested your analytical abilities?
Explain what is the difference between slice and dice and cross tab report?
How to create Index to the table in the universe designer and how it improves the Query performence
Explain what three things do you consider to be the most important factors for a manager?
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 ?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
What are all difference between business objects 6.5 and xi r2?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
Explain what would you consider as your biggest achievement and why?
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 is it the job of a business analyst or systems analyst to draw the class diagram?
