Hi.
In a heap table does index get placed on every column or only some? Can you force uniqueness by using it?
For example, in a product table
ID int PK
product_code varchar(5)
product_abbrv varchar(10)
I need to be able to search quickly by both ID and product_code, and enforce unique product_code to prevent entering new products w/conflicting product codes.
Thanks for reading, any help will be appreciated.
dmcub
In a heap table does index get placed on every column or only some? Can you force uniqueness by using it?
For example, in a product table
ID int PK
product_code varchar(5)
product_abbrv varchar(10)
I need to be able to search quickly by both ID and product_code, and enforce unique product_code to prevent entering new products w/conflicting product codes.
Thanks for reading, any help will be appreciated.
dmcub