title: How to debug a database query for performance
body: <p>I am absolutely new in databases and SQL queries. </p>
  
  <blockquote>
    <p>Q1. What are the common problems one
    generally face in database queries? Probably extremely large queries, performance issues, timeout and connectivity errors, import export and restoration errors</p>
    
    <p>Q2. What approach and tools one should
    be aware of while debugging a SQL
    query performance?</p>
  </blockquote>
  
  <p>It will be great if you can share some of the problems faced and how did you went forward for resolving it.</p>