Skip to main content

Posts

Showing posts with the label Re-indexing

Command to reindiex,update statistics, database tables in sql through query analyzer

Write this command in query editor then run the command to reindex database use yourdatabase dbcc dbreindex('DBNM') Then use this command to update statistics of database update statistics 'DBNM' Command to reindex table DBCC DBREINDEX(YourTableName, '', 80) or DBCC DBREINDEX(YourTableName, '', 70)

Difference Normal INDEX And BITMAP INDEX

Difference Normal INDEX And BITMAP INDEX Normal index is cannot give indexes for Duplicate values in column values But BITMAP INDEX is gives Indexes for duplicate values also depend on Their ROWID. So BITMAP INDEX created on columns containing less distinct values means duplicates contain column for better performance BITMAP INDEX. WE can use B-Tree index where data cardinality is high and many DML operations are performed and have many distinct values. while Bitmap will use when have low cardinality and less distinct value like gender column(M/F) or value does not update frequently