>>Hi,
>>
>>I fount the following script online designed to create an index:
>>
>>
>>CREATE NONCLUSTERED INDEX [MyTableIndex]
>>ON [dbo].[tablename] ([tablename_ID],[tablename_Field1])
>>INCLUDE ([Tablename_Field2],[Tablename_Field3])
>>
>>
>>What I don't understand is the purpose of the INCLUDE syntax. I am actually trying to create a simple index on column REC_ID and
>>I think that my syntax should be:
>>
>>
>>CREATE NONCLUSTERED INDEX [MyTableIndex]
>>ON [dbo].[tablename] ([rec_id])
>>
>>
>>But I want to be sure that I am not missing something important with this INCLUDE. Can anybody explain? TIA.
>
>You may include columns into the index to create covering index.
>
>This blog post has information about it
http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/sql-server-covering-indexesThank you for the link. I will follow it.
"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