RE: SQL-92 query issue

From: Geoff Crawford

Date: 9 Apr 2008

At 02:29 PM 4/9/2008, Schmit, Keith wrote:
>Having suffered at SQL-92's lack of aggression at selecting multiple
>indexes, I cannot emphasize how GOOD it would be if Progress would fix
>that. I had a multi-indexed query that worked fantastically in SQL-89
>that I had to rewrite into app server logic because SQL-92 couldn't
>handle it.
>

How often do you run UPDATE STATISTICS out of curiosity?


=====================================================================
Geoff Crawford                           Phone:      (973) 361 - 4224
Innov8 Computer Solutions, LLC           FAX:        (973) 537 - 6946
711 Route 10 East, Suite 204             Email:    b21b0721-86d0-328b-de11-69013e0103b7
Randolph NJ 07869                        Web: http://www.innov8cs.com

    Progress Blog: http://blogs.ittoolbox.com/database/progress/

              Take a Step Up to StepUp Accounting