摘要： 温馨提醒：TMP_007数据量为：4093731.去除在谓词列上编写的任何标量函数优化前：(耗时3.1s)SELECT START_DATE,CST_NM FROM TMP_007 WHERE YEAR(TO_DATE(START_DATE,'YYYYMMDD'))='2009'优化后：(耗时0.922s)SELECT START_DATE,CST_NM FROM TMP_007 WHERE ST... 阅读全文

摘要： 建表语句CREATE TABLE FUND_DAILY_INCOME ( ID BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY, ACCOUNT_NO VARCHAR(32), CREATED_TIME TIMESTAMP, FUND_CODE VARCHAR(8), ... 阅读全文