Question : PostgreSQL and PostGIS offer to create indexes over GiST with pretty much the same code. On 2D items, […]
Category: Database Index
What is the best order of columns on a compound index?
Question : I have a series of small ‘attribute’ tables (innodb) with this structure: uuid name (TEXT) organisation_id (INT) In […]
Index solution for dynamic query
Question : I have a Credit/Debit table (5 millions records). The application must provide an UI View to search data […]
How to make MySQL use indexes in an integer range select query
Question : I’m doing a select on a table looking for rows that match between an upper and lower bound […]
Super slow MariaDB 5.5 count(*) on large simple table
Question : I’m doing some testing on a dedicated mediocre server (Core 2 2G ram). Before I upgrade to 8G […]
How to determine if an Index is uselss in Percona MySQL?
Question : Using Percona Server 5.5 I’ve a table which stores user activty (lets call it user_activity). It was created […]
The use of NOT logic in relation to indexes
Question : According to Microsoft’s book on database development Exam 70-433: Microsoft SQL Server 2008 Database Development: Neither leading wildcard […]
Advisability of using STATISTICS_NORECOMPUTE
Question : I’ve recently become involved in maintaining a set of databases with some interesting index problems. One of the […]
Spatial Index on an InnoDB table
Question : I have a database which is in InnoDB, because I wanted consistency (cascading delete). Now, I want to […]
InnoDB slow query (few derived and dependent queries)
Question : I have a select query which always worked pretty fast but data kept increasing which is why this […]