Resources for Developers



Spatial indexes to speed coordinate-based searches

Share it!

Share it!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… Continue Reading →

Share it!

Composite indexes – When should you use them in MySQL?

Share it!

Share it!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… Continue Reading →

Share it!


Theme by Iván MelgratiTop ↑