Tag Archives: Index

Day 19 MyIASM Storage engine

MyIASM storage engine is available from the early stage of MySQL this engine is developed from IASM language and it is used for Read intensive operations. As described in yesterday this Engine was default till MySQL 5.5 and is widely … Continue reading

Posted in General, History, Internal, MySQL, Others | Tagged , , , , | Leave a comment

Index Rebuild VS Reorganize

Posted in Basic, Index, Others, Troubleshooting | Tagged | Leave a comment

Denali — Day 5: Column-store indexes (aka Project Apollo)

Denali – Day 5: Column-store indexes (aka Project Apollo)   There is another great achievement for Denali, especially for Data warehouse, where data is static and very huge – READONLY, and user always require data to be retrieved quickly as … Continue reading

Posted in Denali, Index, Performance Tuning | Tagged , , | Leave a comment

Day 7: RE-index job failed – Deadlock

Sometimes our re-index maintenance plan job fails with following error:   Failed:(-1073548784) Executing the query “ALTER INDEX [INX] ON [dbo].[XXX] REBUILD WITH ( FILLFACTOR = 90, PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, SORT_IN_TEMPDB = … Continue reading

Posted in Index, Troubleshooting | Tagged , | Leave a comment

List of indexes and Parallel queries

Today while being on forum found this information so though to blog for future reference. thanx Uri Dimant for sharing this.  WITH cte  AS  (  SELECT object_name(ic.object_id) as object_name , index_name = i.name, ‘column’ = c.name,         ‘column usage’ = … Continue reading

Posted in Index, Performance Tuning, Personal, What I learned today | Tagged | Leave a comment

Reindex and Update stats.

Today I was reading blog by Ben Nevarez it is great… (I am impressed with ben now a days) that’s why Kalen always ask him for reviewing his book (all INSIDE books reviewed by Ben.)   http://sqlblog.com/blogs/ben_nevarez/archive/2009/10/06/rebuilding-indexes-vs-updating-statistics.aspx   update statistics … Continue reading

Posted in What I learned today | Tagged , , | Leave a comment

Select count(*)

  Today I was reading(I always read Paul Randal). http://www.sqlskills.com/BLOGS/PAUL/post/Which-index-will-SQL-Server-use-to-count-all-rows.aspx I learned that whenever you query select count(*) it will select the the best plan… as if no index —no option –table scan INDEX: choose the smallest possible index(if has … Continue reading

Posted in What I learned today | Tagged , | Leave a comment

Conditional reIndex and update stats.

Hi,   This script is very helpful, specially for sql server 2000. I made some changes into this.   —————————->SP BEGIN CREATE PROCEDURE sp_defragment_indexes @maxfrag DECIMAL AS — Declare variables SET NOCOUNT ON DECLARE @tablename VARCHAR (128) DECLARE @execstr VARCHAR … Continue reading

Posted in What I learned today | Tagged , | Leave a comment