Question : I have a very large table (around 140M rows) with five columns: CREATE TABLE IF NOT EXISTS citations […]
Category: Database Index
GETDATE() uniqueness when used on INSERT
Question : Recently I was reading this blog post: http://blogs.msdn.com/b/sqlazure/archive/2010/05/05/10007304.aspx which contains this section: Picking a Clustered Index There are […]
About the Index in MYSQL [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
Conflict resolution for hash-backed unique constraint of large text bodies
Question : So we’ve just run into ERROR: index row size 2736 exceeds maximum 2712 for index “foo__bar__un” Hint: Values […]
SQL Server 2008 – Return records in chronological order, given a separation factor
Question : This question was originally posted here https://stackoverflow.com/questions/8492149/return-records-in-chronological-order-given-a-separation-factor and re-posted on this forum given a user’s advice. I have […]
Questions on database table and index partitioning in SQL Server
Question : I have developed Transact-SQL script to partition the table. To apply the partition, I am creating one non-clustered […]
Offset vs Where performance for pagination with index
Question : Suppose that you have a list of millions of items, each one with a timestamp (created_at). You also […]
Deadlock: How to prevent Primary Key Lock in SELECT
Question : In MySQL 5.7 we are running tracking queries every day at 0:00. Lately, these are causing deadlocks with […]
How do you correct a corrupted index in Oracle? [duplicate]
Question : This question already has answers here: How do you correct a corrupted index in Oracle? (3 answers) Closed […]
Multi table GROUP BY query optimisation
Question : Currently I have a multi table/column GROUP BY query which is pretty slow. Below is the tables schema […]