does sequence of columns in where condition matters the sequence of composite key? in Oracle Database












0















here, In the code where exists clause contains all primary key columns in where, I want to know that the sequence of this columns in it, matters in query performance.




update temp_fd_dtl_svj a
set a.LAST_INT_PAID_DT = ( select max(b.TRAN_DT) from temp_fd_int_svj b
where a.COMP_CD = b.comp_cd and a.BRANCH_CD = b.BRANCH_CD and a.ACCT_CD = b.ACCT_CD
and a.ACCT_TYPE = b.ACCT_TYPE and a.fd_no = b.FD_NO and b.Tran_type in ('I')
)
, a.LAST_PROV_DT = ( select max(b.TRAN_DT) from temp_fd_int_svj b
where a.COMP_CD = b.comp_cd and a.BRANCH_CD = b.BRANCH_CD and a.ACCT_CD = b.ACCT_CD
and a.ACCT_TYPE = b.ACCT_TYPE and a.fd_no = b.FD_NO and b.Tran_type in ('P')
)
, a.LAST_TDS_DT = ( select max(b.TRAN_DT) from temp_fd_int_svj b
where a.COMP_CD = b.comp_cd and a.BRANCH_CD = b.BRANCH_CD and a.ACCT_CD = b.ACCT_CD
and a.ACCT_TYPE = b.ACCT_TYPE and a.fd_no = b.FD_NO and b.Tran_type in ('T')
)
where exists (select *
from temp_fd_int_svj c
where a.acct_cd = c.acct_CD
and a.comp_cd = c.comp_cd
and a.BRANCH_CD = c.BRANCH_CD
AND a.ACCT_TYPE = c.ACCT_TYPE
and a.fd_no = c.FD_NO
)
;









share







New contributor




abhithombare45 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

























    0















    here, In the code where exists clause contains all primary key columns in where, I want to know that the sequence of this columns in it, matters in query performance.




    update temp_fd_dtl_svj a
    set a.LAST_INT_PAID_DT = ( select max(b.TRAN_DT) from temp_fd_int_svj b
    where a.COMP_CD = b.comp_cd and a.BRANCH_CD = b.BRANCH_CD and a.ACCT_CD = b.ACCT_CD
    and a.ACCT_TYPE = b.ACCT_TYPE and a.fd_no = b.FD_NO and b.Tran_type in ('I')
    )
    , a.LAST_PROV_DT = ( select max(b.TRAN_DT) from temp_fd_int_svj b
    where a.COMP_CD = b.comp_cd and a.BRANCH_CD = b.BRANCH_CD and a.ACCT_CD = b.ACCT_CD
    and a.ACCT_TYPE = b.ACCT_TYPE and a.fd_no = b.FD_NO and b.Tran_type in ('P')
    )
    , a.LAST_TDS_DT = ( select max(b.TRAN_DT) from temp_fd_int_svj b
    where a.COMP_CD = b.comp_cd and a.BRANCH_CD = b.BRANCH_CD and a.ACCT_CD = b.ACCT_CD
    and a.ACCT_TYPE = b.ACCT_TYPE and a.fd_no = b.FD_NO and b.Tran_type in ('T')
    )
    where exists (select *
    from temp_fd_int_svj c
    where a.acct_cd = c.acct_CD
    and a.comp_cd = c.comp_cd
    and a.BRANCH_CD = c.BRANCH_CD
    AND a.ACCT_TYPE = c.ACCT_TYPE
    and a.fd_no = c.FD_NO
    )
    ;









    share







    New contributor




    abhithombare45 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.























      0












      0








      0








      here, In the code where exists clause contains all primary key columns in where, I want to know that the sequence of this columns in it, matters in query performance.




      update temp_fd_dtl_svj a
      set a.LAST_INT_PAID_DT = ( select max(b.TRAN_DT) from temp_fd_int_svj b
      where a.COMP_CD = b.comp_cd and a.BRANCH_CD = b.BRANCH_CD and a.ACCT_CD = b.ACCT_CD
      and a.ACCT_TYPE = b.ACCT_TYPE and a.fd_no = b.FD_NO and b.Tran_type in ('I')
      )
      , a.LAST_PROV_DT = ( select max(b.TRAN_DT) from temp_fd_int_svj b
      where a.COMP_CD = b.comp_cd and a.BRANCH_CD = b.BRANCH_CD and a.ACCT_CD = b.ACCT_CD
      and a.ACCT_TYPE = b.ACCT_TYPE and a.fd_no = b.FD_NO and b.Tran_type in ('P')
      )
      , a.LAST_TDS_DT = ( select max(b.TRAN_DT) from temp_fd_int_svj b
      where a.COMP_CD = b.comp_cd and a.BRANCH_CD = b.BRANCH_CD and a.ACCT_CD = b.ACCT_CD
      and a.ACCT_TYPE = b.ACCT_TYPE and a.fd_no = b.FD_NO and b.Tran_type in ('T')
      )
      where exists (select *
      from temp_fd_int_svj c
      where a.acct_cd = c.acct_CD
      and a.comp_cd = c.comp_cd
      and a.BRANCH_CD = c.BRANCH_CD
      AND a.ACCT_TYPE = c.ACCT_TYPE
      and a.fd_no = c.FD_NO
      )
      ;









      share







      New contributor




      abhithombare45 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.












      here, In the code where exists clause contains all primary key columns in where, I want to know that the sequence of this columns in it, matters in query performance.




      update temp_fd_dtl_svj a
      set a.LAST_INT_PAID_DT = ( select max(b.TRAN_DT) from temp_fd_int_svj b
      where a.COMP_CD = b.comp_cd and a.BRANCH_CD = b.BRANCH_CD and a.ACCT_CD = b.ACCT_CD
      and a.ACCT_TYPE = b.ACCT_TYPE and a.fd_no = b.FD_NO and b.Tran_type in ('I')
      )
      , a.LAST_PROV_DT = ( select max(b.TRAN_DT) from temp_fd_int_svj b
      where a.COMP_CD = b.comp_cd and a.BRANCH_CD = b.BRANCH_CD and a.ACCT_CD = b.ACCT_CD
      and a.ACCT_TYPE = b.ACCT_TYPE and a.fd_no = b.FD_NO and b.Tran_type in ('P')
      )
      , a.LAST_TDS_DT = ( select max(b.TRAN_DT) from temp_fd_int_svj b
      where a.COMP_CD = b.comp_cd and a.BRANCH_CD = b.BRANCH_CD and a.ACCT_CD = b.ACCT_CD
      and a.ACCT_TYPE = b.ACCT_TYPE and a.fd_no = b.FD_NO and b.Tran_type in ('T')
      )
      where exists (select *
      from temp_fd_int_svj c
      where a.acct_cd = c.acct_CD
      and a.comp_cd = c.comp_cd
      and a.BRANCH_CD = c.BRANCH_CD
      AND a.ACCT_TYPE = c.ACCT_TYPE
      and a.fd_no = c.FD_NO
      )
      ;







      oracle query-performance oracle-12c postgresql-performance performance-tuning





      share







      New contributor




      abhithombare45 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.










      share







      New contributor




      abhithombare45 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.








      share



      share






      New contributor




      abhithombare45 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked 7 mins ago









      abhithombare45abhithombare45

      1




      1




      New contributor




      abhithombare45 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      abhithombare45 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      abhithombare45 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






















          0






          active

          oldest

          votes











          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "182"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });






          abhithombare45 is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f231886%2fdoes-sequence-of-columns-in-where-condition-matters-the-sequence-of-composite-ke%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes








          abhithombare45 is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          abhithombare45 is a new contributor. Be nice, and check out our Code of Conduct.













          abhithombare45 is a new contributor. Be nice, and check out our Code of Conduct.












          abhithombare45 is a new contributor. Be nice, and check out our Code of Conduct.
















          Thanks for contributing an answer to Database Administrators Stack Exchange!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f231886%2fdoes-sequence-of-columns-in-where-condition-matters-the-sequence-of-composite-ke%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Liste der Baudenkmale in Friedland (Mecklenburg)

          Single-Malt-Whisky

          Czorneboh