Question : I’ve recently become involved in maintaining a set of databases with some interesting index problems. One of the […]
Tag: index
Aren’t two writes required to update a clustered index record
Question : I was reading the article on indexes at simple-talk, where it is written that If a heap has […]
What is the cost of adding a foreign key in mysql?
Question : I have an application which has a product_def table defining all products. The recrods in product_def are fixed […]
looking for missing indexes in the cached execution plans
Question : I have the following query that shows me what is cached in sql server: SELECT cp.objtype AS ObjectType, […]
Attempts to reclaim unused space causes the used space to increase significantly in SQL Server
Question : I have a table in a production database that has a size of 525 GB, of which 383 […]
FillFactor: IndexOptimize script by Ola Hallengren
Question : We are using Ola Hallengren’s IndexOptimize script for index rebuild on SQL Server 2008 and 2012. These maintenance […]
Efficient query to get greatest value per group from big table
Question : Given the table: Column | Type id | integer latitude | numeric(9,6) longitude | numeric(9,6) speed | integer […]
Getting a scan though I expect a seek
Question : I need to optimize a SELECT statement but SQL Server always does an index scan instead of a […]
Are there any benefits in certain ordering of columns when defining indexes
Question : For example, if I have two indexes: CREATE INDEX IDX_1 ON MY_TABLE_1 (ITEM, DATE, LOCATION) COMPUTE STATISTICS; CREATE […]
Mysql might have too many indexes
Question : I am using the php framework Laravel for my application, together with mysql 5.6, in order to have […]