Ergebnis der Suchanfrage

• Forum: Datenbanken

  AW: nested joins check

    Delphi
    by jobo, 18. Jun 2020
  Well, I never understood why people neglegt formating in SQL Statements. Looks a little like masochism. There are even online tools for formatting SQL statements. The suggestion above was done automatically and pimped a little by hand, a matter of seconds.
  
  And I don't know anything about QDA9, but with reference to the naming, You don't have to start with changing column definitions.
  Just...
• Forum: Datenbanken

  AW: nested joins check

    Delphi
    by jobo, 16. Jun 2020
  I guess You are dealing with design data maybe from Solid Edge based on Oracle DB mixed with 2 other Sources, measuring and production database?
  However, it doesn’t look like there is a fine grained consolidation area using well designed tables, indices or API, but more a „pool“ of import / export / ETL sources.
  So maybe a lot of fragments, poorly indexed ....
  
  Tweaking (of existing, working...
• Forum: Datenbanken

  AW: nested joins check

    Delphi
    by jobo, 16. Jun 2020
  Which way to start complex joins is a difficult question.
  In general I would start with the answer:
  It's oracle, the optimizer works quite well, so don't care about performance etc.
  Just use a join style, which suits You and Your understanding of the model / use case.
  
  If you have a working statement You can start tweaking.
  
  Btw. it's also possible and very helpfull to build views, doing...
• Forum: Datenbanken

  AW: nested joins check

    Delphi
    by jobo, 15. Jun 2020
  even more formatting (quite usefull for understanding what's going on)
  
  Select Distinct dm.column17 cell,
  dm.column3 auto_id,
  dm.column5,
  dm.column8 Mod_Status,
  dmZ.column3 BAT,
  dm7.column4 MOD_VST_ID,
  dm7.column8 Mod_Status,
  dm7.ST_DATUM,