Hi!
Some silly comments:
-> |> select count(*) from ainvpost, strcustr, atkliquh, alujobsh,
-> atkliqud where
-> |> atkliquh.inv_num = '12316' and
-> |> atkliquh.inv_num = ainvpost.inv_num and
-> |> ainvpost.c_num = strcustr.cust_code and
^^^^^^^^^^^^^^^^^^
-> |> atkliquh.job_num = alujobsh.job_num and
-> |> atkliquh.tk_num = atkliqud.tk_num
Shame - a FourGen site! My condolences. (Please Loren, don't beat on me!
:)) It's just those table naming conventions I can't get to grips with!
A not so silly comment:
Have you run "update statistics" recently? It can have an amazing effect
on the optimiser's behaviour.
Regards,
Billy
----
Digitec Online - 20 Nodes....* Johannesburg, South Africa +27-11-476-2008
.............................* Best BBS * RsaNET User Choice Awards 1993
first.last@digitec.co.za.....* Best Sysop * RsaNET User Choice Awards 1993