International Journal of Computer Science Issues

More than a traditional journal...

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.