I have a database that has a clustered composite index and 2 non clustered indexes on each of the columns used in the composite index. Doesn't it just need the clustered index?
What is difference between cluster index and non cluster index
Hi, I have one table having more than 3 millions rows with following columns: [SITE_ID] [USER_NAME] [PAGE_TYPE] [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. ...


