Help using Base SAS procedures

Performance for OLAP and OLTP.

Regular Contributor
Posts: 229

Performance for OLAP and OLTP.


if u have millions of records in which u can upload fastly which is better

and for querying which is better OLAP or OLTP.

if this is not the correct forum to post please let me know were to post it.
Super User
Posts: 5,876

Re: Performance for OLAP and OLTP.

A very general question, which have been discussed and declared since the begining of data warehouse and business intelligence.

Yes, OLAP (or any other data structuredata marts, star schemas etc) is a better environment for query, reporting, anysis...

Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation