SQL Table indexes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Henrik - 21 Jun 2005 12:36 GMT

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

Reply to this Message

John Kane - 23 Jun 2005 05:16 GMT

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

Signature

SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/

> 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

Reply to this Message