IMELGRAT.ME

Resources for Developers

Tag

indexes

Spatial indexes to speed coordinate-based searches

Share:

Search operations in databases are usually optimized using indexes as well as careful data modeling. This is also true for coordinate-based databases by using spatial indexes. Optimizing spatial searches is possible with the aid of a great variety of multi-dimensional… Continue Reading →

Share:

Composite indexes – When should you use them in MySQL?

Share:

What are composite indexes? Database engines (e.g. MySQL, PostgreSQL, etc.) can create composite indexes on table data. That is, indexes on multiple columns at once, instead of indexing a single column. For instance, MySQL allows indexes of up to 16… Continue Reading →

Share:

© 2018 IMELGRAT.ME

Theme by Iván MelgratiTop ↑