How to modify SQL queries in best way

There are many ways you can modify a SQL query.

Here I am going to cover two types.

Tip1

  • Take out your production query into test region, and execute and capture results
  • Test your modified query also in test region .
  • Compare your results, then modify your query in production box

    Tip2

    Online SQL is another option. Where you no need to install any SQL development Software. Then you need to create simple tables and then write your SQL and test it. This way testing is highly useful and you can tweak SQL easily.

    Advertisements

    Author: Srini

    Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.