1. 2018-12-13, 04:53 AM (ISO 8601) - Top - End - #5
    Manga Shoggoth
    Manga Shoggoth is online now
    Troll in the Playground
     
    Flumph
    Join Date
    Nov 2006
    Location
    England. Ish.
    Gender
    Male

    Default Re: slowness of SQL UPDATE statements (vs SAS Data Step but any SQL advice welcome)

    In addition to the above...

    Depending on how technical you wish to be, most database systems can tell you how they are actually running the query. Oracle has "explain plan" , for example. If you can get at that information it may show you what you need to fix the query.
    Last edited by Manga Shoggoth; 2018-12-13 at 04:54 AM. Reason: removed irrelevant bit...
    Reply With Quote Reply With Quote