jwcolby
jwcolby at colbyconsulting.com
Thu Jun 11 22:02:05 CDT 2009
Roger that, it is as I suspected. Thanks Arthur. John W. Colby www.ColbyConsulting.com Arthur Fuller wrote: > I looked into this on your behalf and have not come up with anything useful > (c.f. ALTER INDEX etc.). > > My suggestion thereore is to drop the index(es) and create from scratch. > This syntax is trivial and by now I'm sure that you know it by rote. You > have wrestled numeruous pigs in the mud in this app, so I won't bother you > with redundant ops. > > There (IMO) is no advantage to be gained by any ALTER INDEX variation. > Better to DROP INDEX then recreate it according to your new requirements. > > A. > > On Thu, Jun 11, 2009 at 1:46 PM, jwcolby <jwcolby at colbyconsulting.com>wrote: > >> I need to create an index on a table, then use the index to update another >> field, then add that >> other field to the index. Is there a syntax to add a field to an existing >> index or is it just drop >> / create index? >> >> I create indexes in stored procedures, but I have never added another field >> to an existing index. >> >> > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >