Question : I’m attempting to add an index to a very large table (2B rows) and the command fails after […]
Category: Database Index
Online index rebuild snapshot location and impact of filling index drive
Question : My understanding of a rebuild index online operation is that the index will have a snapshot taken and […]
postgres: index to SELECT strings like ‘%foo%’;
Question : I have an expensive, periodic PostgreSQL 9.3 query of the form: SELECT * from mytable where name NOT […]
Is it bad practice to automate the updating of statistics and re-making of query plans on a relatively small SQL Azure database?
Question : I have a SQL Azure database that’s about 500MB in size. Every 2-3 weeks the database will suddenly […]
PostgreSQL – Return unique combinations of columns based on where clause
Question : This is quite a long question, please bear with me. So I’d like to first explain I have […]
When do hash indexes become reasonable?
Question : MySQL natively doesn’t support hash indexes. So, making a pseudo hash column and creating an index on a […]
Postgresql uses slower constraint over faster index
Question : I have a few tables (25m records +) which have a very INSERT, UPDATE and DELETE biased workload […]
Why index is not used with order by?
Question : I trying to get info about why MySQL does not using my index when I create a inner […]
Rebuild index in SQL Server does not reduce fragmentation
Question : I am trying to reduce the fragmentation of my indexes. First of all I rebuild all indexes with […]
PostgreSQL: Table and index on different tablespace
Question : In PostgreSQL i have the freedom of choosing to put index (of a table or materialized view) on […]