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 |
|
desikankannan
Posting Yak Master
152 Posts |
 Posted - 2010-10-20 : 06:13:52
|
| Hi,i have field called balance (numeric 15,2), i want to setindexing for this field to retrive data quicklyhow to set index for the columnpls guide me very urgentDesikankannan |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2010-10-20 : 12:15:41
|
| I'm assuming you want a nonclustered and nonunique index:CREATE NONCLUSTERED INDEX <Index Name> ON <Table Name> (Balance)This is database 101, you should really look at Books Online to get the syntax so you can look this up in the future. |
 |
|
|
|
|
|
set index for a colum