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.
"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