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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-29 : 10:32:36
|
| Prasad V writes "On which fields i should create index? for example if my query has where condition on 'fld1' and 'fld2', should i create indexon 'fld1' and 'fld2' for faster access??? please respond" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-04-29 : 12:04:15
|
quote:
please respond
cute . . .Index strategy is usually not as simple as that... post the ddl (create table statement) for you table and the dml (query) you want to improve with an index. Then also let up know what other activities that particular object partake in . . . the more specific the better.<O> |
 |
|
|
|
|
|
Indexing