how to create indexing in MSSQL?

[enterume]

Hi,

in mysql there is a 'index' features for fast query. How can I do it in MSSQL?

Please give an example or reference.

Thanks in advance.
Louis

[yyogev]

use the standard CREATE INDEX syntax and create the index, then do your query and use DROP INDEX to destroy the index.

Yaron