Improving OLTP and OLAP performance 2/3: Optimizing search queries using database indexes

In this video, Alejandro Duarte demonstrates the importance of database index to improve the performance of filters in Vaadin Flow applications using Spring Boot and MariaDB.

0:00 Intro
0:25 The demo app
1:08 Adding a filter
3:17 Implementing the repository query
5:27 Testing the slow query
6:33 Creating an index
7:37 Analyzing queries with "explain query"
10:22 Testing the improvement
11:40 Outro

Links:

[unikpsc]

can you show how to sort records by date using indexes (without filtering). In this case, oracle does not use the index