International Journal of Application or Innovation in Engineering & Management (IJAIEM)
Database warehouse can be consider as repository for an organization data base client engine want to access the data from data ware house the authors always think about it performance is need to focus on different methods to reduce time to access time. different method are available to reduce it time. This paper provide algorithm which reduce time by considering clustering approach and also by considering common field of different table. The MV view creation and selection is based on the various parameters like access frequency, base update frequency etc.