Thread: Can We create both clustered and clustered indexes on same column
View Single Post
  #1 (permalink)  
Old 07-09-10, 01:19
reddy_546 reddy_546 is offline
Registered User
  
Join Date: May 2010
Location: Hyderabad, India
Posts: 16
Can We create both clustered and Non clustered indexes on same column
I have a table EXT_MEEI_SQL with following info

Column_name Type Length
----------- ---- ----------- -
MEDICAID_ID char 12
MMS_SEQ_NO int 4
SUB_SEQ_NO datetime 8
SQL_LINE1 varchar 255
SQL_LINE2 varchar 255
MESQ_ID numeric (IDENTITY) 9

INDEXES:

index_name (index_keys) index_description
---------- ----------------- ----
EXTX_MESQ_PRIMARY (MESQ_ID) clustered, unique
EXTX_MESQ_ID (MESQ_ID) nonclustered
MEEI_SQL_IDX_MEDMMS (MEDICAID_ID, MMS_SEQ_NO) nonclustered

while inserting data into SQL table deadlock is occurring..Is it because of these clustered and non clustered index on the same column (MESQ_ID)?
__________________
-PavanKumar M Reddy
Last edited by reddy_546; 07-11-10 at 08:13.
Reply With Quote