Trending db2 sql Discussions

Follow

Ask the Community


Ask any professional question and get answers from other specialists.

Stream language
Chiragkumar Maisuriya's image
Question added by Chiragkumar Maisuriya Software Architect/Developer visionaire
10 years ago

When would be the result of Cube & T-SQL different?‎

Cube is essentially SQL Now in what scenario The result data set would be different? Give specific example‎

Answers:
1
Followers:
Views:
214
Vote Count:
0
Answer should contain a minimum of 25 characters.
Ivan Perak's image  
Answer added by  Ivan Perak, Business / Financial Analyst, Hypo Alpe Adria Bank
10 years ago

It depends on what kind of data are you looking for. Cubes give you pre-aggregated results whereas with standard T_SQL queries you have to aggregate them on the fly which ... See More