Go4Expert (http://www.go4expert.com/)
-   Database (http://www.go4expert.com/forums/database-forum/)
-   -   Clustered and Non-clustered Index (http://www.go4expert.com/forums/clustered-clustered-index-t15531/)

plugsharma 17Dec2008 20:12

Clustered and Non-clustered Index
1 Attachment(s)

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














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..



shabbir 17Dec2008 20:14

Re: Clustered and Non-clustered Index
Moved to database forums for better response.

plugsharma 17Dec2008 20:28

Re: Clustered and Non-clustered Index

All times are GMT +5.5. The time now is 05:23.