InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 01:09:59 GMT20http://www.sqlservercentral.com/Forums/Topic464284-146-1.aspxNo, normally you don't have to run update statistics after creating an index. It should have effect on your SQL immediately. Perhaps have a look at your query with execution plan or run query optimizer to see what advices optimizer you gives.Wed, 05 Mar 2008 03:30:09 GMThenri flokstrahttp://www.sqlservercentral.com/Forums/Topic464284-146-1.aspxhello,I was creating index but no effect on my sql transaction. is it neccessary to updating statistic after creating an index to use it ?Wed, 05 Mar 2008 02:45:40 GMTyann.larvor