Hi guys, suppose I had a transactions table that was taking a LONG time to
retrieve data from, especially when filtered. It is indexed on all columns
where criteria to filter is specified. I reindexed (DBCC REINDEX) the table,
and now it runs slower than before, fillfactor was left unchanged. What went
wrong, if anything, and what can I do to make it faster?




MS Sql Server LazyDBA home page