RE: [Emerald] Call Consolidation

Emerald ( (no email) )
Fri, 3 Dec 1999 14:31:49 -0500

> I'm guessing if you are seeing continual table scans, that you have some
> out of date indexes/stats or you are missing some indexes. Check
> instindx.sql
> and see if you have the seven indexes on your calls table that it lists.
> One missing index can change a query from 2 seconds to 2 hours, on a
> large
> table like the calls table.

THANK YOU DALE!! (why don't you take a few tech support questions now and
then, you could cut the load those guys have in half with these quick
answers <g>) Please tell Mike he doesn't need to return my support call
(Netlink).

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
else.

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?

I suppose I should go thru the whole script now and verify that every table
has the indexes in this script.

Geo.

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart