var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Impact of nonclustered index with included columns on large tables
I would like to know the impacts (if any) of adding nonclustered index with included columns on large tables (these tables are populated by bulk insert from text files)
DB2 9.7, 10.5 on Windows
Also, inserts/updates/deletes to the base table will be little costlier as you'll need to make changes to the index as well. And your index will be wider which means more IO.
Thank you very much for the info and the URLs :-)