Hello!
I want to information about INDEXING? Why we creat index and how to creat
and where we can manage index? In SQL 2000 EM where we can see old indexes ?
regards,

Henrik,
SQL Server Books Online (BOL) is the best source of information for this
type of information. If you don't have it on your server, you can search
MSDN for "create index". You can also use the T-SQL system stored procedure
sp_helpindex to gather information on various tables in the sample
databases, such as pubs. As for SQL 2000 EM, you can manage indexes via the
tables and right-clicking on the table and select properties.

Hope that helps!
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/


[quoted text, click to view]