Search results

  1. L

    SQL takes forever

    Hi, No I did not commit my work. I have now tried update table statistics for pub.jobevt; commit; but I get the error "System.Data.Odbc.OdbcException: ERROR [HY000] [DataDirect][ODBC OPENEDGE driver][OPENEDGE]Syntax error in SQL statement at or about "; commit;" (10713)" Any idears...
  2. L

    SQL takes forever

    Hi, I have progress openedge 10.1a driver installed the version is 5.10.0037. I have ran the update SQL to create the indexes for that table but it had no effect. These are what I ran. update table statistics for pub.jobevt update index statistics for pub.jobevt Regards, Loftty
  3. L

    SQL takes forever

    Hi All, I have the below query which is quite simple, but there is 3.5 million records, so the query takes forever. Is there some magic trick I can do to make it faster? SELECT num FROM pub.jobevt I have also tried this but still takes quite a while SELECT num FROM pub.jobevt WHERE...
Back
Top