I've created a new table and added data to it. Now I want to index a given column. Will simply creating and saving the index index the column or do I need to do something else to create the actual index?
Barkingdog
you must run a create index tsql statement to actially create an index
however you can use the enterprise manager or the sql server management studio
the create the index using the GUI
|||Once the index is created it will be maintained by itself, you don′t need to refresh the index. ON the other side, index can get fragmented leading to throttle your response time on the server.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment