• A
  • A
  • A
  • ABC
  • ABC
  • ABC
  • А
  • А
  • А
  • А
  • А
Regular version of the site

Article

Использование индексов в реляционных СУБД

Успехи современной науки. 2017. Т. 6. № 3. С. 38-41.
Вендин А. С.

In this work we consider a solution that helps to increase the speed of search and retrieval of data in relational database management systems, such as ORACLE and MySQL.

This solution is called the index. We consider the types of indexes that are unique only for a particular database and indexes that are used in all DBMS.

The test database for experiments is created. The analysis is performed on certain types of queries, the same for all test databases. Based on the results of queries made a number of recommendations for using specific indexes in data-bases for specific types of request, as well as some general advice on writing relational queries