Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
Category: Database Index
How to create new table with same constraints and indexes?
Question : I am Creating a new table with Primary Key Constraints and a Non Clustered Index in that table. […]
Postgres doesn’t use expression index for group by
Question : I’m doing a simple group by on a single column with a matching index and it works fine: […]
New Index on table cause table to be locked really often
Question : Here are my tables : CREATE TABLE [dbo].[Trackers] ( [IdTracker] INT IDENTITY (1, 1) NOT NULL, [IMEI] NVARCHAR […]
MS SQL Server sys.indexes vs sys.sysindexes system table difference
Question : For indexes there are 2 system tables: sys.indexes and sys.sysindexes. I’d like to know what are their differences. […]
Why is MySQL ignoring my indexes?
Question : I have a query select distinct id from patient where company_id in (1) and (name_last like ‘peter%’ or […]
Is Postgres insert performance the same in the replica
Question : We’ve got a Postgres database with a table that takes heavy select, update and inserts that needs some […]
Efficient pagination for big tables
Question : Using PostgreSQL 10.5. I’m trying to create a pagination system where the user can go back and forth […]
Excluding clustered key columns from non-clustered indexes definitions
Question : As I’ve read the bookmark or the reference of the non-clustered index to the table clustered index is […]
Does PostgreSQL support wildcard indexes on JSON?
Question : I have a multi-tenant service with a table like this: project_id | user_id | user_properties Each project belongs […]