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 |
|
amy
Starting Member
30 Posts |
 Posted - 2002-05-02 : 13:27:10
|
| How can I find out the ID for index.After I rebuilted the Index, I got the message below but how do I know the Index =2, 3, 4?excuted:select *from sysindexesThen I noticed that there is indid there but one id is 255 and I din't see the messge: Index (ID = 25) is being rebuilt? so I am not sure this place is the right place for me to look the indid or not?ThanksIndex (ID = 2) is being rebuilt.Index (ID = 3) is being rebuilt.Index (ID = 4) is being rebuilt.Edited by - amy on 05/02/2002 13:32:00 |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-05-02 : 17:27:27
|
| Text/image columns always show up in sysindexes table as an index with an indid of 255 (despite the fact that there is no index on them)...Those aren't real indexes, so they are never rebuilt...---------------Strong SQL Developer wanted in the Boston area. Please e-mail if interested. |
 |
|
|
|
|
|
ID for Index