Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dasu
Posting Yak Master
104 Posts |
 Posted - 2004-12-20 : 23:30:48
|
| CREATE INDEX emp_tel_idx ON test(id)ON index_fg1so where i need create this file index_fg1.tell me this please.regardsdasu.g |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-21 : 16:29:39
|
| What? Please ask in a different way as I don't understand the question.Tara |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-12-21 : 17:21:20
|
| In query analyzer? I'm not sure I understand the question either.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-12-21 : 23:10:08
|
can't understand your question, this might help though:quote:
CREATE [ UNIQUE ] [ CLUSTERED | NONCLUSTERED ] INDEX index_name ON { table | view } ( column [ ASC | DESC ] [ ,...n ] ) [ WITH < index_option > [ ,...n] ] [ ON filegroup ]< index_option > :: = { PAD_INDEX | FILLFACTOR = fillfactor | IGNORE_DUP_KEY | DROP_EXISTING | STATISTICS_NORECOMPUTE | SORT_IN_TEMPDB }
--------------------keeping it simple... |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2004-12-22 : 10:13:23
|
| BOL... Is there anything it can't do?Still it amazes me the number of people who don't use it as a first point of knowledge.HTH=================================================================Sometimes I wonder whether the world is being run by smart people who are putting us on or by imbeciles who really mean it. -Mark Twain, author and humorist (1835-1910) |
|
|
|
|
|
|
about indexing