IMELGRAT.ME

Resources for Developers

Tag

indexes

Spatial indexes to speed coordinate-based searches

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 →

Composite indexes – When should you use them in MySQL?

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 →

© 2017 IMELGRAT.ME — Powered by WordPress

Theme by Iván MelgratiUp ↑