Performance Issues and Query Optimization in Big Multidimensional Data

SQL queries for big-data and multidimensional data need to be carefully coded to get maximum benefit of optimization and to improve the performance of the system and the applications involved. This is especially true for online applications where there is a race against time in populating the results set. Valuable time and cost can be saved by optimizing query statements during their design process especially when they are required to perform complex process involving relationships with the other tables. The relationships with the tables vary from complex joins to sorting order which has direct impact on system performance. Transactions SQL (TSQL), stored procedures, triggers etc. Can be efficiently coded to optimize a query. Queries involved in 3D databases depend on user interaction have a human element added in the optimization process. This paper addresses few of the issues using a number of potential applications.