Versions Compared

Old Version 10

changes.mady.by.user Pablo Beltran

Saved on

compared with

New Version Current

changes.mady.by.user Pablo Beltran

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The main tricks to write the best performing queries possible are (already explained in sections before):

JQL

...

queries perform better than SQL

  • Rely on Jira JQL queries as much as possible to do the work even building JQL queries in SQL queries dynamically. This is an advanced topic as very few users are used to joining tables in this way and it is critical in many queries for the real world.

...