Question : We have a SQL 2016 database that has a 1.9bn row table which has a varbinary(255) column which […]
Category: Database Index
What indexes should one use for this two-table setup?
Question : I have the following two-table setup: CREATE TABLE relationships ( id bigint(20) NOT NULL AUTO_INCREMENT, type varchar(20) COLLATE […]
Save performance with large update on Index with Included Column
Question : Points —————— PK QuestionId int (+30.000.000 distinct values) PK EventId int (large batches where 80.000 rows have the […]
Optimizing table/indices for getting the latest row (filtering by one additional column)
Question : I have a SQL Server table (SQL Server 2012 SP3 Standard edition) that stores a bunch of configuration […]
Why would CREATE INDEX with “online” mode suddenly slow my database down?
Question : Earlier I used CREATE INDEX … WITH(ONLINE=ON) without any problems – the statement would run in parallel with […]
MySQL How to Script to create indexes on all date columns in database
Question : I have a lot of tables in the database that are using a datetime stamp – I need […]
Mysql – How number of columns effect the database performance
Question : I have a table to store social media information for users; I have 42 columns to store and […]
Does MySQL exectution plan depend on available indexes?
Question : Does MySQL choose an execution plan for a given query taking into account what indexes are available, or […]
Query to retrieve index details for a particular column in all tables
Question : There is a column created_at in most of tables. I would like to get the details if that […]
MySQL – Indexes deleted, reduced column size but table size increases
Question : Here is the original table definition which contains 107547934 (~107.5M) rows CREATE TABLE `twitter_tweets` ( `id_str` varchar(100) CHARACTER […]