Ok. I'll tell him.
> That was it, there were only 3 indexes and after creating the other 4 I'm
> guessing but it looks like it will finish in about 10 minutes like everyone
> BTW, I tried to run the full instindx.sql script just now and even though it
> completed (with errors about already existing indexes) it did not create the
> other 4 indexes but when I ran each line separately for the 4 indexes it did
> indeed create them. Any idea why that would happen?
Because all the indexes for the Calls table are in a batch (notice
only one go after them all). If any fail, they all fail. Put a
GO between each one, then you could run it.
> I suppose I should go thru the whole script now and verify that every table
> has the indexes in this script.
It might be helpful. Most of the Emerald table are not large enough
to see such a dramatic speed different, although you might notice a
speed increase on billing, if you have all the right indexes.
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart