MySQL Forums
Forum List  »  Newbie

Re: Syntax for UPDATING a table with result of an Aggregate (GROUP BY) Inner Join Function
Posted by: Amanda J
Date: November 01, 2017 10:45PM

Can I ask with a multiplying series of temporary tables storing intermediate aggregate results used in subsequent calculations is the better approach going forward:

    - keep creating temporary tables
    - create stored procedures (just discovering these)
    - create views (haven't got to this tab in the manual yet)
"better" in terms of:
    - db optimisation,
    - db size,
    - scalability,
    - professionalism

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.