title: What are the ways to reduce the time taken by a Select query?
body: <p>I am creating an API in JSP for my oracle database.</p>
  
  <p>I have two tables containing 20k records each. I need to perform a natural join, the result will be shown in a JSP page in JSON format. My problem is it is taking almost 3mins to load the JSON page.</p>
  
  <p>Please tell me how do I improve the performance in my page?</p>