Any question answered...

You are reading a single comment by @Emyr and its replies. Click here to read the full conversation.

•

Emyr
ok....anyone got any tips on improving speed of reports? asked google, tried some things, still cant figure it out.

Does when a join is created in the order of statements make a difference (provided it works) to speed?
1. Which DBMS?
  1A. If MS SQL, they have tools which can both predict the execution plan and tools which monitor active servers.
  1B. If MySQL/MariaDB, InnoDB or MyISAM?
2. Are you joining on indexes/PKs?

About

Avatar for Emyr @Emyr started