"Ian Boyd" <admin@SWIFTPA.NET> wrote in message
news:eu3MR9gpHHA.4032@TK2MSFTNGP02.phx.gbl...
> The table being indexed has only one changed row, but when i do an
> incremental population the table is being hit millions of times (millions
> of rows). The table has a timestamp column.
>
> How can i make incremental population only index rows that have changed?
>
>
>
> (i already know the answer - incremental population is essentially the
> same as full population. i'm just venting)
>
> "If you have 50 million rows in your database, this procedure will be
> issued 50 million times.
> On the other hand, if you use incremental population this statement will
> also be issued 50 million times."
> - Hilary Cotter

> Change tracking is the best option for what you are looking for.