>>I have never heard of rebuilding indexes not being recommended. Do you have any good references to support that statement?
>
>Most database engines recommends it. In VFP, we also had to use the same route to make sure we have a brand new properly created index. Earlier on this thread, I believe I also saw a mention that it is better to create the index.
AFAIK - When you rebuild an index in sql server it is creating an entirely new index from scratch and deleting the old one. I think you're making that process harder than it needs to be.
Regarding rebuilding indexes in VFP, I drop and re-create as well. Not so with SQL server.
Brandon Harker
Sebae Data Solutions