TY - JOUR ID - 129022 TI - Indexed View Technique to Speed-up Data Warehouse Query Processing JO - The ISC International Journal of Information Security JA - ISECURE LA - en SN - 2008-2045 AU - M. J. Al Taleb, Talib AU - Hasan, Sami AU - Yousif Mahdi, Yaqoob AD - College of Information Engineering, Al-Nahrain University, Baghdad, Iraq. Y1 - 2020 PY - 2020 VL - 12 IS - 3 SP - 81 EP - 85 KW - Data Warehouse (Star Schema) KW - Indexed View KW - Query Processing DO - 10.22042/isecure.2021.271059.615 N2 - The data warehouse size and query complexity may cause an unacceptable delay in decision support queries. A basic condition for the success of a data warehouse is the capability to supply decision-makers with both precise information and best response time. For this purpose, the concept of indexed views is used. Indexed views help to speed-up query processing and reduce the response time for tracing queries, especially for queries about past histories. Indexed views may significantly by reducing the amount of work that SQL Server to return the required data and im- prove query performance and solve the problem of decision support workloads. this article is applicable to data warehouse de-signed by using SQL Server. It is not applicable if the data warehouse was designed by using another software like Oracle, DB2 and Informix. For many years, Mi- Microsoft SQL Server has supported the ability to create virtual tables known as views. UR - https://www.isecure-journal.com/article_129022.html L1 - https://www.isecure-journal.com/article_129022_31178a2e55a219f9220ba666f6bf933d.pdf ER -