文章基本信息

标题：Impact of table partitioning on the query execution performance
本地全文：下载
作者：Jaumin Ajdari ; Nehat Mustafa ; Xhemal Zenuni 等
期刊名称：International Journal of Computer Science Issues
印刷版ISSN：1694-0784
电子版ISSN：1694-0814
出版年度：2016
卷号：13
期号：4
出版社：IJCSI Press
摘要：With the increase of database, it is commonly to have tables with a considerable number of data records. This will bring delays in database use specially in query execution. A good way to improve performance and reduce the time is by applying the partitioning technique, which are known as techniques that restructures the table data records. Partitioning is a good way to simplify database maintenance, management and administration and as well as working with queries. A very important advantage of using partitioning is that it allows to query and scan just a small part or some parts of partitioned tables. In this research we examine the use of partitioning techniques on relatively large table and we measure the query execution time and cost. As a result, we have shown some comparisons and given suggestions how to further increase the performance.
关键词：Partitioning; Query execution time; Partition pruning; Paper Specifications; Partition;wise join.