Thank you. Then I will create a separate index on site_no.
>SQL Server cannot use this index for site_no
>
>>
>>I am changing the index tags for many SQL Server tables and would like to understand something.
>>
>>Here is an example and a question. Say I have a table with a Char field/column (CUSTOMER_ID) and an Integer field/column (SITE_NO). I create a unique index key on thee two column; as the following:
>>
>>CREATE UNIQUE INDEX PX_CUST_SITE ON MyTable (customer_id, site_no )
>>
>>When a SQL Select will be executed against either one of these fields, customer_id or site_no, will SQL Server use this index? Or I need to create to more separate indexes, one on CUSTOMER_ID and another on SITE_NO?
>>TIA
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham