Indexing a table

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

Indexing a table

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

Basically all you have to do is expand the table right click Indexes select New Index Select your type clustered or non-clustered and add the index key column field. There are many more option depending on what your needs are. How this helped.