Clustered and Non-clustered Index

plugsharma's Avatar, Join Date: Nov 2008
Newbie Member
Hi,

I have one table having more than 3 millions rows with following columns:

[SITE_ID]

[USER_NAME]

[ACTIVITY_NAME]

[PAGE_TYPE]

[ACTION]

[DOC_ID]

[FROM_PAGE]

[TO_PAGE]

[ORG_NAME]

[LOG_DATE_TIME]

[SESSION_ID]

[IP]

[MACHINE_ID]



I am using 8 different queries, all thru stored procedure, to fetch data.

SITE_ID, USER_NAME, ORG_NAME and ACTION are in all queries WHERE clause.

I have created SITE_ID as non-unique clustered index and USER_NAME, ORG_NAME and ACTION as non-unique non-clustered index.

Problem is that data fetching without indexs is faster than when creating idex.

Is there any problem in index columns.

Can you please suggest me a better index plan.

I have attached the queries / column table image file.


Please help..


Thanks

Sharma
Attached Images
File Type: jpg Queries-Columns.jpg (59.6 KB, 1 views)
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Moved to database forums for better response.
plugsharma's Avatar, Join Date: Nov 2008
Newbie Member
Thanks