Question : I have this query: SELECT * FROM location WHERE to_tsvector(‘simple’,unaccent2(“city”)) @@ to_tsquery(‘simple’,unaccent2(‘wroclaw’)) order by displaycount I’m happy with […]
Category: Database Index
Simple Slow Query Not Using Indexes
Question : I have a slow query running on a large forum. The EXPLAIN synopsis: mysql> EXPLAIN SELECT COUNT(post_thanks.id) as […]
Postgres – how to alter the WHERE clause of a postgres index
Question : I need to insert a new two-field index on an existing table with about 600 million rows in […]
Index is not used with same Query on two Servers [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
Sort index doesn’t work for MySQL
Question : I have a table with more than a million records. I get the data by using LIMIT, but […]
SQL Deadlock graph – Find exact statement holding the lock and the time it started [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
Defragmentation – Rebuilding Indexes SQL Server 2005
Question : I’m researching defragmenting databases and it seems the following SQL statement is what I’m looking for: ALTER INDEX […]
How to speed up query on table with millions of rows
Question : The Issue: I’m working on a big table that consists about 37mln rows. Data include measurements of many […]
SQL Server Update Statement joining on index column
Question : Using SQL Server 2012, I have a stored procedure that updates data by doing a delete and insert […]
Having different Table space for different indexes of same table, will causes any performance impact?
Question : Table Master_Table is created in App1_Schema1. Index_I01 is created in default TABLE SPACE. Index_I02 is created in TABLE […]