Indexing in sql server 2005

[pratimapaudel]

I have tables in my database, it's sql server 2005.
I heard some of them have indexing and some of them doesnot have indexing.

If i want to check whether it has indexing or not how do i do?

And if i want to create indexing how do i do?

Do i have to write script to create indexing or i can do from desing view of management studio?
if i have to write script to create indexing where do i write?

Thanks in advance for your help.

[ck9663]

I have tables in my database, it's sql server 2005.
I heard some of them have indexing and some of them doesnot have indexing.

If i want to check whether it has indexing or not how do i do?

And if i want to create indexing how do i do?

Do i have to write script to create indexing or i can do from desing view of management studio?
if i have to write script to create indexing where do i write?

Thanks in advance for your help.

Open your Management Studio. Go to the table you want to check. Expand the table. Check the index in Indexes.

-- CK

[pratimapaudel]

Open your Management Studio. Go to the table you want to check. Expand the table. Check the index in Indexes.

-- CK

Thanks but how do i do indexing?

[ck9663]

Right click on the "Indexes" tree and choose New Index.

-- CK

[pratimapaudel]

Right click on the "Indexes" tree and choose New Index.

-- CK

Thanks for you reply.
I will try now.
thanks