Data warehouses are designed to accommodate ad hoc queries. You might not know the workload of your data warehouse in advance, so a data warehouse should be optimized to perform well for a wide variety of possible query operations.OLTP systems support only predefined operations. Your applications might be specifically tuned or designed to support only these operations.