What is difference between Union and Union All ?

Answer Posted / sagar

1) By union ALL u will get duplicate records also(the records common between 2 tables 2 times) but Union gives u union of 2 tables
2) 'Union All' is faster than Union

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is fact degradation?

566


Does microstrategy intelligence server run on windows®, unix®, or linux®?

544


How do users receive only information that they want?

538


Explain heterogeneous mapping?

555


What are objects?

571






What are the programs that we can do with the microstrategy architect?

565


Explain fact constellation schema?

570


Your application mode has crashed. How would you get the instance back?

531


Explain system call error?

598


Explain the difference between rolap and molap?

551


Explain security role?

544


Your application mode has crashed. How would you run your i-server?

563


what are the different types of fact structures?

542


what do you mean by passthrough functions?

548


Difference between project merge and object manager in microstrategy?

592