how to create non clustered index? means syntax.
-
Hi all
how to create non clustered index? means syntax.
if on one field clustered index defined, is it allow non clusted
index on that field?
will one field allow two indexes or not?
-
Check syntax on MSDN site:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create_64l4.asp
More about indexes, see 'Lesson 3: Creating Indexes':
http://www.microsoft.com/technet/prodtechnol/sql/70/books/c0618260.mspx
Before asking this kind of questions, use google instead.
(e.g. 'MSDN create index ')
Regrads
Max
-
Lets not be too hard on him, we were all newbies once and it's fairly obvious he's just starting out (or needs to find out for an assignment)
That said, I agree, there are hundreds of places that this information is available from without needing to ask here and i'm glad that you gave him somewhere to start looking.
-
I must also point out that the clustered index will be contained in all other indexes so there's no need to explicitly reindex it.
-
So, what do you think, a genuine newbie or someone with an assignment they need to have answers for?
It's farily obvious that they've never used SQL before. Maybe we should ask Steve for a forum especially for 'assignment' questions, that way if we're bored we can post a bit there
-
Won't ever be that bored.... unless it's a really good question.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply