Go4Expert

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

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
 
Thanks


All times are GMT +5.5. The time now is 08:32.