What is difference between OLAP and OLTP?

1.	What is difference between OLAP and OLTP?
Answer» Indexes − OLTP system has only few indexes while in an OLAP system there are many indexes for performance optimization. Joins − In an OLTP system, large number of joins and data is normalized however in an OLAP system there are less joins and de-normalized. Aggregation − In an OLTP system data is not aggregated while in an OLAP database more aggregations are used.

Answer»

Indexes − OLTP system has only few indexes while in an OLAP system there are many indexes for performance optimization.

Joins − In an OLTP system, large number of joins and data is normalized however in an OLAP system there are less joins and de-normalized.

Aggregation − In an OLTP system data is not aggregated while in an OLAP database more aggregations are used.

Discussion