title: Reaching to the effective performance level of the query
body: <p>I have this below oracle query Please advise me how can I make it more efficient so that it performance will improve , let me know please if i i have miss anything in it as I am a new one ,any early help would be much appreciated</p>
  
  <p>below is the Plan for the query , Please advise how can i improve it </p>
  
  <pre><code>Plan hash value: 44516869
  
  ---------------------------------------------------------------------------------------------------
  | Id  | Operation                     | Name              | Rows  | Bytes | Cost (%CPU)| Time     |
  ---------------------------------------------------------------------------------------------------
  |   0 | SELECT STATEMENT              |                   |  1099 | 39564 |  3770   (1)| 00:00:46 |
  |*  1 |  HASH JOIN                    |                   |  1099 | 39564 |  3770   (1)| 00:00:46 |
  |   2 |   NESTED LOOPS                |                   |       |       |            |          |
  |   3 |    NESTED LOOPS               |                   |  1095 | 32850 |  3345   (1)| 00:00:41 |
  |   4 |     TABLE ACCESS FULL         | BUSINESS_CONTACTS |  1666 | 14994 |    11   (0)| 00:00:01 |
  |*  5 |     INDEX UNIQUE SCAN         | PERSON_PK         |     1 |       |     
  </code></pre>