https://communities.sas.com/t5/SAS-Procedures/Performance-for-OLAP-and-OLTP/m-p/14420#M2299 A very general question, which have been discussed and declared since the begining of data warehouse and business intelligence.<BR /> <BR /> Yes, OLAP (or any other data structuredata marts, star schemas etc) is a better environment for query, reporting, anysis...<BR /> <BR /> /Linus Thu, 02 Apr 2009 10:00:48 GMT LinusH 2009-04-02T10:00:48Z https://communities.sas.com/t5/SAS-Procedures/Performance-for-OLAP-and-OLTP/m-p/14419#M2298 HI <BR /> <BR /> if u have millions of records in which u can upload fastly which is better<BR /> <BR /> and for querying which is better OLAP or OLTP.<BR /> <BR /> if this is not the correct forum to post please let me know were to post it. Thu, 02 Apr 2009 09:51:04 GMT https://communities.sas.com/t5/SAS-Procedures/Performance-for-OLAP-and-OLTP/m-p/14419#M2298 R_Win 2009-04-02T09:51:04Z https://communities.sas.com/t5/SAS-Procedures/Performance-for-OLAP-and-OLTP/m-p/14420#M2299 A very general question, which have been discussed and declared since the begining of data warehouse and business intelligence.<BR /> <BR /> Yes, OLAP (or any other data structuredata marts, star schemas etc) is a better environment for query, reporting, anysis...<BR /> <BR /> /Linus Thu, 02 Apr 2009 10:00:48 GMT https://communities.sas.com/t5/SAS-Procedures/Performance-for-OLAP-and-OLTP/m-p/14420#M2299 LinusH 2009-04-02T10:00:48Z