Resources for Developers



Spatial indexes to speed coordinate-based searches

Share this article:

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 this article:

Composite indexes – When should you use them in MySQL?

Share this article:

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 this article:


Theme by Iván MelgratiTop ↑