为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:DM7
【操作系统】：
【CPU】:
【问题描述】*：
我执行该sql不走索引。我的pdate已经建立了索引的。
SELECT YDDYID,JYQX CJQX FROM NMJY.T_SBS_XHJYJS_JYTS_CJMX_FYDJY WHERE PDATE = '2023-07-31'
建表语句：
CREATE TABLE "NMJY"."T_SBS_XHJYJS_JYTS_CJMX_FYDJY"
(
"MONTH" VARCHAR2(50),
"SEQID" VARCHAR2(50),
"FDDYID" VARCHAR2(50),
"YDDYID" VARCHAR2(50),
"JYQX" TEXT,
"BIDSIGN" VARCHAR2(50),
"JYTYPE" VARCHAR2(50),
"SDCUSTOMID" VARCHAR2(50),
"ID" VARCHAR2(100) NOT NULL,
"PDATE" VARCHAR2(50) NOT NULL,
"SBSJ" DATETIME(6),
"TQTYPE" VARCHAR2(50),
"SFCS" VARCHAR2(50),
"TQUSER" VARCHAR2(50),
"TQDATE" DATETIME(6),
NOT CLUSTER PRIMARY KEY("ID", "PDATE"))
PARTITION BY RANGE("PDATE")
(
PARTITION "P20221231" VALUES LESS THAN('2022-12-31'),
PARTITION "P20230131" VALUES LESS THAN('2023-01-31'),
PARTITION "P20230231" VALUES LESS THAN('2023-02-31'),
PARTITION "P20230331" VALUES LESS THAN('2023-03-31'),
PARTITION "P20230430" VALUES LESS THAN('2023-04-30'),
PARTITION "P20230531" VALUES LESS THAN('2023-05-31'),
PARTITION "P20230630" VALUES LESS THAN('2023-06-30'),
PARTITION "P20230731" VALUES LESS THAN('2023-07-31'),
PARTITION "P20230831" VALUES LESS THAN('2023-08-31'),
PARTITION "P20230930" VALUES LESS THAN('2023-09-30'),
PARTITION "P20231031" VALUES LESS THAN('2023-10-31'),
PARTITION "P20231130" VALUES LESS THAN('2023-11-30'),
PARTITION "P20231231" VALUES LESS THAN('2023-12-31'),
PARTITION "P20240131" VALUES LESS THAN('2024-01-31'),
PARTITION "P20240231" VALUES LESS THAN('2024-02-31'),
PARTITION "P20240331" VALUES LESS THAN('2024-03-31'),
PARTITION "P20240430" VALUES LESS THAN('2024-04-30'),
PARTITION "P20240531" VALUES LESS THAN('2024-05-31'),
PARTITION "P20240630" VALUES LESS THAN('2024-06-30'),
PARTITION "P20240731" VALUES LESS THAN('2024-07-31'),
PARTITION "P20240831" VALUES LESS THAN('2024-08-31'),
PARTITION "P20240930" VALUES LESS THAN('2024-09-30'),
PARTITION "P20241031" VALUES LESS THAN('2024-10-31'),
PARTITION "P20241130" VALUES LESS THAN('2024-11-30'),
PARTITION "P20241231" VALUES LESS THAN('2024-12-31'),
PARTITION "P20250131" VALUES LESS THAN('2025-01-31'),
PARTITION "P20250231" VALUES LESS THAN('2025-02-31'),
PARTITION "P20250331" VALUES LESS THAN('2025-03-31'),
PARTITION "P20250430" VALUES LESS THAN('2025-04-30'),
PARTITION "P20250531" VALUES LESS THAN('2025-05-31'),
PARTITION "P20250630" VALUES LESS THAN('2025-06-30'),
PARTITION "P20250731" VALUES LESS THAN('2025-07-31'),
PARTITION "P20250831" VALUES LESS THAN('2025-08-31'),
PARTITION "P20250930" VALUES LESS THAN('2025-09-30'),
PARTITION "P20251031" VALUES LESS THAN('2025-10-31'),
PARTITION "P20251130" VALUES LESS THAN('2025-11-30'),
PARTITION "P20251231" VALUES LESS THAN('2025-12-31'),
PARTITION "PMAX" VALUES LESS THAN(MAXVALUE)
) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE INDEX "SEQID_PDATE" ON "NMJY"."T_SBS_XHJYJS_JYTS_CJMX_FYDJY"("SEQID" ASC,"PDATE" ASC) STORAGE(ON "MAIN", CLUSTERBTR) ;
CREATE INDEX "T_SBS_XHJYJS_JYTS_CJMX_FYDJY_FQ_PDATE" ON "NMJY"."T_SBS_XHJYJS_JYTS_CJMX_FYDJY"("PDATE" ASC) STORAGE(ON "MAIN", CLUSTERBTR) ;