Question : i have two tables in Oracle 11g server one is partitioned and another is having a 3GB of […]
Category: Database Index
Reducing table size bytes per row in a simple PostgreSQL database
Question : I have a pretty simple 3 column table in postgresql 11. It’s timeseries data and the table can […]
Is there a situation where MySQL creates a nonclustered index automatically?
Question : MySQL creates a clustered index automatically when I create a primary key. But is there a situation where […]
How to tell if an index has OPTIMIZE_FOR_SEQUENTIAL_KEY turned on?
Question : SQL Server 2019 brings the OPTIMIZE_FOR_SEQUENTIAL_KEY option that, as far as I know you specify on index creation […]
Oracle index with REGEXP_REPLACE is it a good idea?
Question : I have a table of contacts with 1 million registers and now the user wants to search in […]
Use of Non clustered Indexes
Question : I know the differences between clustered and non-clustered indexes. Can someone tell me the various scenarios where we […]
Is two separate index equals to a composite index?
Question : For example, this is a sample table id int PK, pid int, cid int, deleted int, createdAt timestamp, […]
Suggestion on Missing Index Creation
Question : I have been using sp_blitzindex and it is very very helpful(Thanks to Brent Ozar and Team). I executed […]
PostgreSQL: Find rows for which any index of any value contained is over a given size
Question : I have a database originally built with an instance of PostgreSQL with a custom page size much larger […]
Should I create a multi-column UNIQUE index?
Question : I have created the following MySQL table, which stores which sections of our site a user visited (and […]