Re: SQL Query Optmizer

Posted in 1994

Billy Wheeler — 26 Mar 94 18:39:00 GMT — source: Informix-list mailing list archive (1991-1998)

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