Parallelism: Interference between the data and indexes using major of indexing types

摘要

As in engineering and research, database tuning becomes an inescapable part of big projects since the conception phase. The needs of companies including big data have increased to databases optimization. A lot of systems cause many blockages at least the five years after the production, because they didn't take into account the optimization and its rules since the conception phase, these reasons were of a paramount of importance to prepare this paper. Indexing is the most suitable way to optimize databases system, further one of the best ways of optimizing the index is the application of parallelization. In this paper we will talk about parallelization, and we will use different query with different types of indexes and we will compare the results gotten from each index, to top it all, the most suitable interference between the major types of index: b*tree index, bitmap index, composite index, local index and global index.