| 00:00:01<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n <\/p>\n \u4ece\u6267\u884c\u8ba1\u5212\u770b\uff0cOracle\u9009\u62e9\u4e86HASH JOIN ANTI\uff0cJOIN\u7684\u4e24\u5f20\u8868\u90fd\u662fT_NUM\uff0c\u4e14\u90fd\u91c7\u7528\u4e86\u5168\u8868\u626b\u63cf\uff0c\u5e76\u672a\u9009\u62e9\u7d22\u5f15\u3002\u4ec5\u9760\u6267\u884c\u8ba1\u5212\u4e5f\u53ea\u7b49\u5f97\u5230\u4e0a\u9762\u7684\u7ed3\u8bba\uff0c\u81f3\u4e8e\u4e3a\u4ec0\u4e48\u4e0d\u9009\u62e9\u7d22\u5f15\uff0c\u4ee5\u53ca\u4e3a\u4ec0\u4e48\u6267\u884c\u65f6\u95f4\u8fc7\u957f\uff0c\u8fd8\u9700\u8981\u8fdb\u4e00\u6b65\u7684\u5206\u6790\u3002<\/p>\n \u5c06\u539fSQL\u8fdb\u884c\u7b80\u5355\u8131\u5bc6\u6539\u5199\u540e\uff0c SQL\u6587\u672c\u7c7b\u4f3c\u5982\u4e0b\uff1a<\/p>\n <\/p>\n SELECT BEGIN, END, ROWID, LENGTH(BEGIN)<\/p>\n FROM T_NUM A<\/p>\n WHERE NOT EXISTS (<\/p>\n SELECT 1<\/p>\n FROM T_NUM B<\/p>\n WHERE B.BEGIN <= A.BEGIN<\/p>\n AND B.END >= A.END<\/p>\n AND B.ROWID != A.ROWID<\/p>\n AND LENGTH(B.BEGIN) = LENGTH(A.BEGIN));<\/p>\n <\/p>\n \u5982\u679c\u5206\u6790SQL\u8bed\u53e5\uff0c\u4f1a\u53d1\u73b0\u8fd9\u662f\u4e00\u4e2a\u81ea\u5173\u8054\u8bed\u53e5\uff0c\u5728BEGIN\u5b57\u6bb5\u957f\u5ea6\u76f8\u7b49\u7684\u524d\u63d0\u4e0b\uff0c\u60f3\u8981\u627e\u5230\u54ea\u4e9b\u4e0d\u5b58\u5728BEGIN\u6bd4\u5f53\u524d\u8bb0\u5f55BEGIN\u5c0f\u4e14END\u6bd4\u5f53\u524d\u8bb0\u5f55END\u5927\u7684\u8bb0\u5f55\u3002<\/p>\n \u7b80\u5355\u4e00\u70b9\u8bf4\uff0c\u8868\u4e2d\u7684\u8bb0\u5f55\u8868\u793a\u7684\u662f\u7531BEGIN\u5f00\u59cb\u5230END\u622a\u81f3\u7684\u8303\u56f4\uff0c\u90a3\u4e48\u5f53\u524d\u60f3\u8981\u83b7\u53d6\u7684\u7ed3\u679c\u662f\u627e\u51fa\u54ea\u4e9b\u6ca1\u6709\u8303\u56f4\u6240\u5305\u542b\u7684\u8303\u56f4\u3002\u9700\u8981\u6ce8\u610f\u7684\u662f\uff0c\u5bf9\u4e8e\u5f53\u524d\u7684SQL\u903b\u8f91\uff0c\u5982\u679c\u5b58\u5728\u4e24\u6761\u8303\u56f4\u5b8c\u5168\u76f8\u540c\u7684\u8bb0\u5f55\uff0c\u90a3\u4e48\u6700\u7ec8\u8fd9\u4e24\u6761\u8bb0\u5f55\u90fd\u4f1a\u88ab\u820d\u5f03\u3002<\/p>\n \u4e1a\u52a1\u7684\u903b\u8f91\u5e76\u4e0d\u662f\u7279\u522b\u590d\u6742\uff0c\u4f46\u662f\u8981\u89e3\u51b3\u4e00\u6761\u8bb0\u5f55\u4e0e\u5176\u4ed6\u8bb0\u5f55\u8fdb\u884c\u6bd4\u8f83\uff0c\u591a\u534a\u91c7\u7528\u7684\u65b9\u6cd5\u662f\u81ea\u5173\u8054\uff0c\u800c\u5728\u8fd9\u4e2a\u81ea\u5173\u8054\u4e2d\uff0c\u65e2\u6709\u5927\u4e8e\u7b49\u4e8e\u53c8\u6709\u5c0f\u4e8e\u7b49\u4e8e\uff0c\u8fd8\u6709\u4e0d\u7b49\u4e8e\uff0c\u4ec5\u6709\u7684\u4e00\u4e2a\u7b49\u4e8e\u7684\u5173\u8054\u6761\u4ef6\uff0c\u6765\u81ea\u8303\u56f4\u6bb5BEGIN\u7684\u957f\u5ea6\u7684\u6bd4\u8f83\u3002<\/p>\n \u663e\u800c\u6613\u89c1\u7684\u662f\uff0c\u5982\u679c\u662f\u8303\u56f4\u6bb5\u672c\u8eab\u7684\u6bd4\u8f83\uff0c\u5176\u9009\u62e9\u5ea6\u4e00\u822c\u8fd8\u662f\u4e0d\u9519\u7684\uff0c\u4f46\u662f\u5982\u679c\u53ea\u662f\u6bd4\u8f83\u5176\u957f\u5ea6\uff0c\u90a3\u4e48\u65e0\u7591\u5bb9\u6613\u4ea7\u751f\u5927\u91cf\u7684\u91cd\u590d\uff0c\u6bd4\u5982\u5728\u8fd9\u4e2a\u4f8b\u5b50\u4e2d\uff1a<\/p>\n <\/p>\n SQL> select length(begin), count(*) from t_num group by length(begin) order by 2 desc;<\/p>\n <\/p>\n LENGTH(BEGIN)\u00a0\u00a0 COUNT(*)<\/p>\n ————- ———-<\/p>\n 12\u00a0\u00a0\u00a0\u00a0\u00a0 22096<\/p>\n 11\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 9011<\/p>\n 13\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 8999<\/p>\n 14\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 8186<\/p>\n 16\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 49<\/p>\n 9\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 45<\/p>\n 8\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 41<\/p>\n 7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 27<\/p>\n <\/p>\n \u5927\u91cf\u91cd\u590d\u7684\u6570\u636e\u51fa\u73b0\u5728\u957f\u5ea6\u4e3a11\u523014\u7684\u8303\u56f4\u4e0a\uff0c\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u4ec5\u6709\u7684\u4e00\u4e2a\u7b49\u503c\u5224\u65ad\u6761\u4ef6LENGTH(BEGIN)\u662f\u975e\u5e38\u4f4e\u6548\u7684\uff0c\u8fd9\u65f6\u4e00\u6761\u8bb0\u5f55\u6839\u636e\u8fd9\u4e2a\u7b49\u503c\u6761\u4ef6\u4f1a\u5173\u8054\u5230\u8fd1\u4e07\u6761\u8bb0\u5f55\uff0c\u8bbe\u7f6e\u5173\u8054\u5230\u4e24\u4e07\u591a\u6761\u8bb0\u5f55\uff0c\u663e\u7136\u5927\u91cf\u7684\u5b9e\u8df5\u6d88\u8017\u5728\u4f4e\u6548\u7684\u8fde\u63a5\u8fc7\u7a0b\u4e2d\u3002<\/p>\n \u518d\u6765\u770b\u4e00\u4e0b\u5177\u4f53\u7684SQL\u8bed\u53e5\uff0c\u4f1a\u53d1\u73b0\u51e0\u4e4e\u6ca1\u6709\u529e\u6cd5\u5efa\u7acb\u7d22\u5f15\uff0c\u56e0\u4e3aLENGTH(BEGIN)\u7684\u9009\u62e9\u5ea6\u975e\u5e38\u67e5\uff0c\u800c\u5176\u4ed6\u7684\u6761\u4ef6\u90fd\u662f\u4e0d\u7b49\u67e5\u8be2\uff0c\u9009\u62e9\u5ea6\u4e5f\u4e0d\u4f1a\u597d\uff0c\u5373\u4f7f\u5efa\u7acb\u7d22\u5f15\uff0c\u5f3a\u5236\u6267\u884c\u9009\u62e9\u7d22\u5f15\uff0c\u6548\u7387\u4e5f\u4e0d\u4f1a\u597d\u3002<\/p>\n \u90a3\u4e48\u5982\u679c\u60f3\u8981\u7ee7\u7eed\u4f18\u5316\u8fd9\u4e2aSQL\uff0c\u5c31\u53ea\u5269\u4e0b\u4e00\u4e2a\u529e\u6cd5\uff0c\u90a3\u5c31\u662fSQL\u7684\u6539\u5199\u3002\u5bf9\u4e8e\u81ea\u5173\u8054\u67e5\u8be2\u800c\u8a00\uff0c\u6700\u4f73\u7684\u6539\u5199\u65b9\u6cd5\u662f\u5229\u7528\u5206\u6790\u51fd\u6570\uff0c\u5176\u5f3a\u5927\u7684\u884c\u7ea7\u5904\u7406\u80fd\u529b\uff0c\u53ef\u4ee5\u5728\u4e00\u6b21\u626b\u63cf\u8fc7\u7a0b\u4e2d\u83b7\u5f97\u4e00\u6761\u8bb0\u5f55\u4e0e\u5176\u4ed6\u8bb0\u5f55\u7684\u5173\u7cfb\uff0c\u4ece\u800c\u6d88\u9664\u4e86\u81ea\u5173\u8054\u7684\u5fc5\u8981\u6027\u3002<\/p>\n SQL\u6539\u5199\u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n <\/p>\n SELECT BEGIN, OLDEND END, LENGTH(BEGIN)<\/p>\n FROM (<\/p>\n SELECT BEGIN, OLDEND, END, LENGTH(BEGIN), COUNT(*) OVER(PARTITION BY LENGTH(BEGIN), BEGIN, OLDEND) CN,<\/p>\n ROW_NUMBER() OVER(PARTITION BY LENGTH(BEGIN), END ORDER BY BEGIN) RN<\/p>\n FROM<\/p>\n (<\/p>\n SELECT BEGIN, END OLDEND, MAX(END) OVER(PARTITION BY LENGTH(BEGIN) ORDER BY BEGIN, END DESC) END<\/p>\n FROM T_NUM<\/p>\n )<\/p>\n )<\/p>\n WHERE RN = 1<\/p>\n AND CN = 1;<\/p>\n <\/p>\n \u7b80\u5355\u7684\u8bf4\uff0c\u5185\u5c42\u7684\u5206\u6790\u51fd\u6570MAX\u7528\u6765\u6839\u636eBEGIN\u4ece\u5c0f\u5230\u5927\uff0cEND\u4ece\u5927\u5230\u5c0f\u7684\u6761\u4ef6\uff0c\u786e\u5b9a\u6bcf\u4e2a\u8303\u56f4\u5bf9\u5e94\u7684\u6700\u5927\u7684END\u7684\u503c\u3002\u800c\u5916\u5c42\u7684\u4e24\u4e2a\u5206\u6790\u51fd\u6570\uff0cCOUNT\u7528\u6765\u53bb\u6389\u5b8c\u5168\u91cd\u590d\u7684\u8bb0\u5f55\uff0c\u800cROW_NUMBER\u7528\u6765\u83b7\u53d6\u8303\u56f4\u6700\u5927\u7684\u8bb0\u5f55\uff08\u4e5f\u5c31\u662f\u6ca1\u6709\u88ab\u5176\u4ed6\u8bb0\u5f55\u7684\u8303\u56f4\u6240\u6db5\u76d6\uff09\u3002<\/p>\n \u6539\u5199\u540e\uff0c\u8fd9\u4e2aSQL\u907f\u514d\u5bf9\u81ea\u5173\u8054\uff0c\u4e5f\u5c31\u4e0d\u5b58\u5728\u5173\u8054\u6761\u4ef6\u91cd\u590d\u503c\u8fc7\u9ad8\u7684\u6027\u80fd\u9690\u60a3\u4e86\u3002\u5728\u6a21\u62df\u73af\u5883\u4e2d\uff0c\u6027\u80fd\u5bf9\u6bd4\u5982\u4e0b\uff1a<\/p>\n SQL> SELECT BEGIN, END, ROWID, LENGTH(BEGIN)<\/p>\n 2\u00a0 FROM T_NUM A<\/p>\n 3\u00a0 WHERE NOT EXISTS (<\/p>\n 4\u00a0\u00a0\u00a0\u00a0 SELECT 1<\/p>\n 5\u00a0\u00a0\u00a0\u00a0 FROM T_NUM B<\/p>\n 6\u00a0\u00a0\u00a0\u00a0 WHERE B.BEGIN <= A.BEGIN<\/p>\n 7\u00a0\u00a0\u00a0\u00a0 AND B.END >= A.END<\/p>\n 8\u00a0\u00a0\u00a0\u00a0 AND B.ROWID != A.ROWID<\/p>\n 9\u00a0\u00a0\u00a0\u00a0 AND LENGTH(B.BEGIN) = LENGTH(A.BEGIN))<\/p>\n 10\u00a0 ;<\/p>\n <\/p>\n 48344 rows selected.<\/p>\n <\/p>\n Elapsed: 00:00:57.68<\/p>\n <\/p>\n Execution Plan<\/p>\n ———————————————————-<\/p>\n Plan hash value: 2540751655<\/p>\n <\/p>\n ————————————————————————————<\/p>\n | Id\u00a0 | Operation\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | Name\u00a0 | Rows\u00a0 | Bytes |TempSpc| Cost (%CPU)| Time\u00a0\u00a0\u00a0\u00a0 |<\/p>\n ————————————————————————————<\/p>\n |\u00a0\u00a0 0 | SELECT STATEMENT\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 48454 |\u00a0 1703K|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0 275\u00a0\u00a0 (1)| 00:00:04 |<\/p>\n |*\u00a0 1 |\u00a0 HASH JOIN ANTI\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 48454 |\u00a0 1703K|\u00a0 1424K|\u00a0\u00a0 275\u00a0\u00a0 (1)| 00:00:04 |<\/p>\n |\u00a0\u00a0 2 |\u00a0\u00a0 TABLE ACCESS FULL| T_NUM | 48454 |\u00a0\u00a0 851K|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0 68\u00a0\u00a0 (0)| 00:00:01 |<\/p>\n | \u00a0\u00a03 |\u00a0\u00a0 TABLE ACCESS FULL| T_NUM | 48454 |\u00a0\u00a0 851K|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0 68\u00a0\u00a0 (0)| 00:00:01 |<\/p>\n ————————————————————————————<\/p>\n <\/p>\n Predicate Information (identified by operation id):<\/p>\n —————————————————<\/p>\n <\/p>\n 1 – access(LENGTH(TO_CHAR(“B”.”BEGIN”))=LENGTH(TO_CHAR(“A”.”BEGIN”)))<\/p>\n filter(“B”.”BEGIN”<=”A”.”BEGIN” AND “B”.”END”>=”A”.”END” AND<\/p>\n “B”.ROWID<>”A”.ROWID)<\/p>\n <\/p>\n <\/p>\n Statistics<\/p>\n ———————————————————-<\/p>\n 0\u00a0 recursive calls<\/p>\n 0\u00a0 db block gets<\/p>\n 404\u00a0 consistent gets<\/p>\n 0\u00a0 physical reads<\/p>\n 0\u00a0 redo size<\/p>\n 2315794\u00a0 bytes sent via SQL*Net to client<\/p>\n 35966\u00a0 bytes received via SQL*Net from client<\/p>\n 3224\u00a0 SQL*Net roundtrips to\/from client<\/p>\n 0\u00a0 sorts (memory)<\/p>\n 0\u00a0 sorts (disk)<\/p>\n 48344\u00a0 rows processed<\/p>\n <\/p>\n SQL> SELECT BEGIN, OLDEND END, LENGTH(BEGIN)<\/p>\n 2\u00a0 FROM (<\/p>\n 3\u00a0\u00a0\u00a0\u00a0 SELECT BEGIN, OLDEND, END, LENGTH(BEGIN), COUNT(*) OVER(PARTITION BY LENGTH(BEGIN), BEGIN, OLDEND) CN,<\/p>\n 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ROW_NUMBER() OVER(PARTITION BY LENGTH(BEGIN), END ORDER BY BEGIN) RN<\/p>\n 5\u00a0\u00a0\u00a0\u00a0 FROM<\/p>\n 6\u00a0\u00a0\u00a0\u00a0 (<\/p>\n 7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SELECT BEGIN, END OLDEND, MAX(END) OVER(PARTITION BY LENGTH(BEGIN) ORDER BY BEGIN, END DESC) END<\/p>\n 8\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FROM T_NUM<\/p>\n 9\u00a0\u00a0\u00a0\u00a0 )<\/p>\n 10\u00a0 )<\/p>\n 11\u00a0 WHERE RN = 1<\/p>\n 12\u00a0 AND CN = 1;<\/p>\n <\/p>\n 48344 rows selected.<\/p>\n <\/p>\n Elapsed: 00:00:00.72<\/p>\n <\/p>\n Execution Plan<\/p>\n ———————————————————-<\/p>\n Plan hash value: 1546715670<\/p>\n <\/p>\n ——————————————————————————————<\/p>\n | Id\u00a0 | Operation\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | Name\u00a0 | Rows\u00a0 | Bytes |TempSpc| Cost (%CPU)| Time\u00a0\u00a0\u00a0\u00a0 |<\/p>\n ——————————————————————————————<\/p>\n |\u00a0\u00a0 0 | SELECT STATEMENT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 48454 |\u00a0 2460K|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0 800\u00a0\u00a0 (1)| 00:00:10 |<\/p>\n |*\u00a0 1 |\u00a0 VIEW\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 48454 |\u00a0 2460K|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0 800\u00a0\u00a0 (1)| 00:00:10 |<\/p>\n |*\u00a0 2 |\u00a0\u00a0 WINDOW SORT PUSHED RANK|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 48454 |\u00a0 1845K|\u00a0 2480K|\u00a0\u00a0 800\u00a0\u00a0 (1)| 00:00:10 |<\/p>\n |\u00a0\u00a0 3 |\u00a0\u00a0\u00a0 WINDOW BUFFER\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 48454 |\u00a0 1845K|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0 800\u00a0\u00a0 (1)| 00:00:10 |<\/p>\n |\u00a0\u00a0 4 |\u00a0\u00a0\u00a0\u00a0 VIEW\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 48454 |\u00a0 1845K|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0 311\u00a0\u00a0 (1)| 00:00:04 |<\/p>\n |\u00a0\u00a0 5 |\u00a0\u00a0\u00a0 \u00a0\u00a0WINDOW SORT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 48454 |\u00a0\u00a0 662K|\u00a0 1152K|\u00a0\u00a0 311\u00a0\u00a0 (1)| 00:00:04 |<\/p>\n |\u00a0\u00a0 6 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TABLE ACCESS FULL\u00a0 | T_NUM | 48454 |\u00a0\u00a0 662K|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0 68\u00a0\u00a0 (0)| 00:00:01 |<\/p>\n ——————————————————————————————<\/p>\n <\/p>\n Predicate Information (identified by operation id):<\/p>\n —————————————————<\/p>\n <\/p>\n 1 – filter(“RN”=1 AND “CN”=1)<\/p>\n 2 – filter(ROW_NUMBER() OVER ( PARTITION BY LENGTH(TO_CHAR(“BEGIN”)),”END”<\/p>\n ORDER BY “BEGIN”)<=1)<\/p>\n <\/p>\n <\/p>\n Statistics<\/p>\n ———————————————————-<\/p>\n 0\u00a0 recursive calls<\/p>\n 0\u00a0 db block gets<\/p>\n 202\u00a0 consistent gets<\/p>\n 0\u00a0 physical reads<\/p>\n 0\u00a0 redo size<\/p>\n 1493879\u00a0 bytes sent via SQL*Net to client<\/p>\n 35966\u00a0 bytes received via SQL*Net from client<\/p>\n 3224\u00a0 SQL*Net roundtrips to\/from client<\/p>\n 3\u00a0 sorts (memory)<\/p>\n 0\u00a0 sorts (disk)<\/p>\n 48344\u00a0 rows processed<\/p>\n <\/p>\n \u539fSQL\u8fd0\u884c\u65f6\u95f4\u63a5\u8fd11\u5206\u949f\uff0c\u800c\u6539\u5199\u540e\u7684SQL\u8bed\u53e5\u53ea\u9700\u89810.72\u79d2\uff0c\u6267\u884c\u65f6\u95f4\u53d8\u4e3a\u539f\u672c\u76841\/80\uff0c\u903b\u8f91\u8bfb\u51cf\u5c11\u4e00\u534a\u3002<\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" \u6700\u8fd1\u78b0\u5230\u4e00\u4e2a\u5355\u6761SQL\u8fd0\u884c\u6548\u7387\u4e0d\u4f73\u5bfc\u81f4\u6570\u636e\u5e93\u6574\u4f53\u8fd0\u884c\u8d1f\u8f7d\u8f83\u9ad8\u7684\u95ee\u9898\u3002 \u5206\u6790\u3001\u5b9a\u4f4d\u6570\u636e\u5e93\u7684\u4e3b\u8981\u8d1f\u8f7d\u662f\u8fd9\u6761\u8bed\u53e5\u5f15\u8d77\u7684\u8fc7\u7a0b\u76f8\u5bf9\u7b80\u5355\uff0c\u901a\u8fc7AWR\u62a5\u544a\u5c31\u53ef\u4ee5\u6bd4\u8f83\u5bb9\u6613\u7684\u5b8c\u6210\u5b9a\u4f4d\uff0c\u8fd9\u91cc\u5c31\u4e0d\u8d58\u8ff0\u4e86\u3002 \u73b0\u5728\u76f4\u63a5\u770b\u4e00\u4e0b\u8fd9\u4e2a\u5bfc\u81f4\u6027\u80fd\u95ee\u9898\u7684SQL\u8bed\u53e5\uff0c\u5176\u5bf9\u5e94\u7684SQL REPORT\u7edf\u8ba1\u5982\u4e0b\uff1a Stat Name Statement Total Per Execution % Snap Total Elapsed Time (ms) 363,741 363,740.78 8 .42 CPU Time (ms) 362,770 362,770.00 8 .81 Executions 1 Buffer Gets 756 756.00 0.00 Disk Reads 0 0.00 … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[1297,593],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-op","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1513"}],"collection":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1513"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1513\/revisions"}],"predecessor-version":[{"id":1514,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1513\/revisions\/1514"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1513"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1513"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1513"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}} |