Adding/Altering the Indexing - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Adding/Altering the Indexing

Author

Topic

dewacorp.alliances

452 Posts

Posted - 2009-03-16 : 16:07:35

Hi there

Currently, I have 2 indexes in the table.

1) IX_prf_BatchItems
COlumns: AccountNo (ASC), Code1 (ASC), Code2 (ASC), Code3 (ASC)
Is Unique: No
Type: Index
Fill Factor: 100
Pad Index: No
Re-compute statistic: No

2) PK_prf_BatchItems
This is the primary key

Due to the data in this table has 15+ records on it, through the GUI I can't just add extra column in th IX_prf_BatchItems cause I got the time out issue. The only way is to though TSQL stuff. Do I need to drop this and recreate or can I just altered it?

Thanks

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-03-17 : 05:22:04

You need to drop and recreate the index (or create ... with drop_existing). If you look at the script that the gui generates, you'll see it's doing exactly that.

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources