Avoid blind queries, because they are executed without filters and therefore fetch large data sets. Performance could be an issue with these queries and can easily overload the system. All Transactional Business Intelligence queries on large transaction tables should be time bound. For example, have a time dimension filter and additional filters to restrict by key dimensions supplier, buyer, worker, item, and so on. In addition, apply filters to columns that have database indexes in the transaction tables. This ensures a good execution plan is generated for the BI query.