Select * FROM pr_risk_control where its_order_no='wsj_test_90 and input=' 13054519090 ';
4.56 seconds -

Select 1 FROM pr_risk_control where its_order_no='wsj_batch_tels115 and input=' 13054519090 'and rownum=1;
0.26 seconds -

Qualitative leap, go back to study well...

CodePudding user response:

Obviously, you both inequitable, and compare their performance (time), and it's not a real meaning;

CodePudding user response:

Two statements fortunately inequitable, or efficiency is about the same slow, elder sister really can't face to particularly high performance requirements of boss...

CodePudding user response:

refer to the second floor lansesl2008 response:

two statements luckily inequitable, or efficiency is about the same slow, elder sister really can't face to particularly high performance requirements of boss...

The original poster is what want to do ~ ~

CodePudding user response:

In order to performance, pursuit is speed!