• A
  • A
  • A
  • АБВ
  • АБВ
  • АБВ
  • A
  • A
  • A
  • A
  • A
Обычная версия сайта
  • RU
  • EN
  • HSE University
  • Publications
  • Book chapter
  • Использование индексов в реляционных СУБД
  • RU
  • EN
Расширенный поиск
Высшая школа экономики
Национальный исследовательский университет
Priority areas
  • business informatics
  • economics
  • engineering science
  • humanitarian
  • IT and mathematics
  • law
  • management
  • mathematics
  • sociology
  • state and public administration
by year
  • 2027
  • 2026
  • 2025
  • 2024
  • 2023
  • 2022
  • 2021
  • 2020
  • 2019
  • 2018
  • 2017
  • 2016
  • 2015
  • 2014
  • 2013
  • 2012
  • 2011
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • 2004
  • 2003
  • 2002
  • 2001
  • 2000
  • 1999
  • 1998
  • 1997
  • 1996
  • 1995
  • 1994
  • 1993
  • 1992
  • 1991
  • 1990
  • 1989
  • 1988
  • 1987
  • 1986
  • 1985
  • 1984
  • 1983
  • 1982
  • 1981
  • 1980
  • 1979
  • 1978
  • 1977
  • 1976
  • 1975
  • 1974
  • 1973
  • 1972
  • 1971
  • 1970
  • 1969
  • 1968
  • 1967
  • 1966
  • 1965
  • 1964
  • 1963
  • 1958
  • More
Subject
News
May 15, 2026
Preserving Rationality in a Period of Turbulence
The HSE International Laboratory for Logic, Linguistics and Formal Philosophy studies logic and rationality in a transformed world characterised by a diversity of logical systems and rational agents. The laboratory supports and develops academic ties with Russian and international partners. The HSE News Service spoke with the head of the laboratory, Prof. Elena Dragalina-Chernaya, about its work.
May 15, 2026
‘All My Time Is Devoted to My Dissertation
Ilya Venediktov graduated from the Master’s programme at the HSE Tikhonov Moscow Institute of Electronics and Mathematics through the combined Master’s–PhD track and is currently studying at the HSE Doctoral School of Engineering Sciences. At present, he is undertaking a long-term research internship at the University of Science and Technology of China in Hefei, where he is preparing his dissertation. In this interview, he explains how an internship differs from an academic mobility programme, discusses his research topic, and describes the daily life of a Russian doctoral student in China.
May 15, 2026
‘What Matters Is Not What You Study, but Who You Study with
Katerina Koloskova began studying Arabic expecting to give it up after a year—now she cannot imagine her life without it. In an interview for the Young Scientists of HSE University project, she spoke about two translated books, an expedition to Socotra, and her love for Bethlehem.

 

Have you spotted a typo?
Highlight it, click Ctrl+Enter and send us a message. Thank you for your help!

Publications
  • Books
  • Articles
  • Chapters of books
  • Working papers
  • Report a publication
  • Research at HSE

?

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

С. 13–16.
Вендин А. С.

In this paper, we consider a solution that helps increase the search speed and data fetching in relational databases such as Oracle and MySQL. This solution is called an index. We consider types of indices, which are unique only for specific DBMS, and indexes, which are used in almost all databases. Created by test database for experiments. The analysis is carried out on certain types of queries that are the same for all investigated DBMS. Based results of the work of the requests, a number of recommendations on the use of indices in specific DBMS and for specific types of query, as well as a number of common recommendations for writing relational queries.

Language: Russian
Full text
Text on another site
Keywords: indexиндексMySQLOracleMySQLOracleSQLСУБДSQLRDBMS

In book

Интеллектуальный и научный потенциал XXI века: сборник статей Международной научно-практической конференции: в 4 частях. 2017
Ч. 3. , Уфа: Общество с ограниченной ответственностью "ОМЕГА САЙНС", 2017.
Similar publications
Национальная мощь современных государств: концептуализация, операционализация, методы анализа и рейтинг
Melville A. Y., Каберник В. В., Mironyuk M. et al., Полис. Политические исследования 2025 № 5 С. 94–111
This article develops an understanding of various aspects of the concept of national power in political science and international studies. National power is understood primarily as a measurable ability of an actor to influence the behavior of other actors in politics. This influence can be exercised though various means. Authors continue the research initiated at ...
Added: September 23, 2025
Изучение основ языка SQL
Karpova I. P., Вендин А. С., [б.и.], 2025.
The laboratory works are devoted to the study of SQL, the query language for databases. His work includes the study of relational algebra operations, data definition language, data manipulation language, simple and complex data queries, and representations. For students of the II-IV courses of technical faculties studying automated information systems and database systems. ...
Added: April 2, 2025
Обоснование приоритетных сценариев развития атомной энергетики для достижения ЦУР в условиях цифровизации с использованием индекса устойчивого развития
Galkina A. N., Экономика устойчивого развития 2023 № 4(56) С. 278–282
Purpose: the purpose of the article is on the basis of existing methods for assessing the achievement of integral indicators of the Sustainable Development Goals (SDGs) to develop a modified index considering the digitalization level, to conduct testing in relation to nuclear power development projects as one of global initiatives areas to achieve the SDGs, ...
Added: January 5, 2025
Индекс этичности российских банков на основе искусственного интеллекта
Storchevoy M., Parshakov P., Paklina S. et al., Доклады Российской академии наук. Математика, информатика, процессы управления (ранее - Доклады Академии Наук. Математика) 2024 Т. 520 № 6 С. 70–81
Measuring a company's ethics is an important element in the mechanism of regulating the behavior of market participants, as it allows consumers and regulators to make better decisions, which has a disciplining effect on companies. We tested various methods of machine analysis of consumer feedback from Russian banks and developed an Ethics Index that allows ...
Added: October 31, 2024
Политика в отношении школьного выбора в постсоветских странах: опыт построения индекса
Anchikov K., Zair-Bek S. I., Mertsalova T., Журнал исследований социальной политики 2024 Т. 22 № 2 С. 209–224
The article is devoted to a comparative analysis of national educational policies in the field of school choice in the countries of the former Soviet Union. The aim of the study is to analyze the transformation of education policy after the collapse of the USSR – the transition from the unified Soviet system to sovereign ...
Added: July 19, 2024
Создание и использование индексов в реляционных базах данных: Методические указания к лабораторной работе №5 по курсу "Базы данных"
Karpova I. P., М.: МИЭМ НИУ ВШЭ, 2024.
The laboratory work is devoted to the study of the rules for creating and using indexes to speed up the execution of queries in SQL. The work can be performed under Oracle or PostgreSQL DBMS management. For students of the II-IV courses of technical faculties studying automated information systems and database systems. ...
Added: January 20, 2024
Spatial Data Management
Rodriges Zalipynis R. A., St. Petersburg: Naukoemkie Technologii, 2023.
Experts estimate that location (spatial) components are part of about 80% of all data in the world. Spatial Data are crucial for Urban, Forest, and Water Management, Rapid Response to Emergencies, Air Quality Control, Food Security, Environmental Monitoring, and myriads of other practical tasks. The Course Syllabus (Curriculum) proposes to acquire fundamental knowledge and skills in ...
Added: January 19, 2024
Эмпирические вызовы и методологические подходы в сравнительной политологии (сквозь призму “Политического атласа современного мира 2.0”)
Melville A. Y., Мальгин А. В., Mironyuk M. et al., Полис. Политические исследования 2023 № 5 С. 153–171
In recent decades, the expanding volume, diversity and coverage of data have created new or have transformed existing areas of research. They have also turned data into a key element of politics today. In this context, the status of empirical research that became the political science mainstream at the turn of the 20th - 21st ...
Added: September 29, 2023
“Политический атлас современного мира 2.0”: к постановке исследовательской задачи
Melville A. Y., Мальгин А. В., Mironyuk M. et al., Полис. Политические исследования 2023 № 2 С. 72–87
This article gives an overview of the consortium between MGIMO-University and HSE University that was launched in 2022 to jointly implement the “Political Atlas of the Modern World 2.0” research project. Among the central objectives of this project is the study of the characteristics of states that determine their positions within the modern world system. ...
Added: March 24, 2023
Adaptation of the middle class to innovation: perception of new technologies and openness to them
Pishnyak A., Khalina N., Population and Economics 2022 Vol. 6 No. 3 P. 80–100
In the modern world, a key skill is the ability to adapt to changing conditions, including mastering new programs, devices, technologies, ways to search for information, and sometimes new professions. With the outbreak of the pandemic – in the context of restrictive measures and transition to remote forms of employment – the problem of adaptation ...
Added: November 9, 2022
Сборка, хранение и предобработка коллекции документов для обучения multi-label классификатора текстов на естественном русском языке
Krayushkin O., Смирнов М., Чернобай Ю., В кн.: 1st conference on Software Engineering and Information Management (SEIM-2016).: СПб.: [б.и.], 2016.
в работе были выявлены основные особенности организации сборки, хранения и предобработки датасета для формирования обучающей выборки multi-label классификатора текстов на естественном русском языке ...
Added: November 4, 2021
Индекс особой точки векторного поля или 1-формы на орбифолде
Gusein-Zade S., Алгебра и анализ 2021 Т. 33 № 3 С. 73–84
Indices of singular points of a vector field or of a 1-form on a smooth manifold are closely related with the Euler characteristic through the classical Poincar\'e--Hopf theorem. Generalized Euler characteristics (additive topological invariants of spaces with some additional structures) are sometimes related with corresponding analogues of indices of singular points. Earlier, there was defined ...
Added: May 2, 2021
Опыт построения индекса динамики социально-политической нестабильности
Bilyuga S., Malkov S. Y., В кн.: Системный мониторинг глобальных и региональных рисковЧ. 1. Т. 11.: Издательство "Учитель", 2020. С. 455–469.
Added: January 12, 2021
К построению индекса социально-политической дестабилизации в различных мир-системных зонах
Медведев И. А., Korotayev A., В кн.: Системный мониторинг глобальных и региональных рисковЧ. 1. Т. 11.: Издательство "Учитель", 2020. С. 436–457.
Added: January 12, 2021
“Политический атлас современности” revisited
Melville A. Y., Mironyuk M., Полис. Политические исследования 2020 № 6 С. 41–61
In this article, we present the results of the development of the “Political Atlas of the Modern World” (“Atlas 1.0”) project. “Atlas-1.0” was implemented more than ten years ago by scholars of the MGIMO University with the support of the Institute of Public Projects and the “Expert” magazine. Development of five complex indices – of stateness, external and ...
Added: December 1, 2020
  • About
  • About
  • Key Figures & Facts
  • Sustainability at HSE University
  • Faculties & Departments
  • International Partnerships
  • Faculty & Staff
  • HSE Buildings
  • HSE University for Persons with Disabilities
  • Public Enquiries
  • Studies
  • Admissions
  • Programme Catalogue
  • Undergraduate
  • Graduate
  • Exchange Programmes
  • Summer University
  • Summer Schools
  • Semester in Moscow
  • Business Internship
  • Research
  • International Laboratories
  • Research Centres
  • Research Projects
  • Monitoring Studies
  • Conferences & Seminars
  • Academic Jobs
  • Yasin (April) International Academic Conference on Economic and Social Development
  • Media & Resources
  • Publications by staff
  • HSE Journals
  • Publishing House
  • iq.hse.ru: commentary by HSE experts
  • Library
  • Economic & Social Data Archive
  • Video
  • HSE Repository of Socio-Economic Information
  • HSE1993–2026
  • Contacts
  • Copyright
  • Privacy Policy
  • Site Map
Edit