Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is the difference between datawarehousing and businessintelligence?

1083


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?

2210


How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1116


Can we Save (save as) WEBI Doc as DESKI?

8134


When we use aggregate awareness function in designer?

956


Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

2384


What is object stores?

968


any difficulitis have you phase while creating bo reports and how did u solve it

3433


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 ?

2040


Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

3055


how many reports have u created ? explain a few.

2073


How were the reports scheduled and how to resolve unexecuted documents?

2655


Explain what are the steps to be taken to schedule the report?

1087


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?

2015


What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

2891