为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】： win10
【CPU】:
【问题描述】*：加查询条件就查询慢 这个字段加上索引了
CREATE TABLE "OSMS"."DM_DATA_FILE_2"
(
"FILE_ID" BIGINT NOT NULL,
"FILE_PID" BIGINT,
"POOL_ID" BIGINT,
"FILE_SIZE" BIGINT,
"FILE_NAME" VARCHAR(255),
"FILE_PATH" VARCHAR(255),
"ABSOLUTE_PATH" VARCHAR(255),
"ALIAS" VARCHAR(255),
"FILE_TYPE" INT,
"ORIGINA_FILE_ID" BIGINT,
"LOCK_STATE" INT,
"FILE_RUN_STATE" INT,
"FILE_STATE" INT,
"IS_DELETE" VARCHAR(255),
"CUT_COMPRESS" VARCHAR(255),
"FILE_FIX" VARCHAR(255),
"FILE_LEV" BIGINT,
"DISC_ID" BIGINT,
"MD5" VARCHAR(255),
"CRC32" VARCHAR(255),
"FILE_MODE" INT,
"COPIES_TASK_ID" BIGINT,
"PACKAGE_ID" BIGINT,
"DISK_NUM_START" INT,
"DISK_NUM_END" INT,
"OFF_SET_LOCAL_HEADER" BIGINT,
"PACK_DISC_PATH" VARCHAR(255),
"CREATE_TIME" TIMESTAMP(6),
"UPDATE_TIME" TIMESTAMP(6),
"ACCESS_DATE" TIMESTAMP(6),
"STOR_STATE" INT,
"IS_BURN_OVER" INT,
"CREATE_USER" VARCHAR(255),
"INDEX_FILE_PATH" VARCHAR(255),
"DISK_STATUS" INT,
NOT CLUSTER PRIMARY KEY("FILE_ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE INDEX "IDX_CREATE_TIME_2" ON "OSMS"."DM_DATA_FILE_2"("CREATE_TIME" ASC) STORAGE(ON "MAIN", CLUSTERBTR) ;
CREATE INDEX "IDX_FILE_NAME_2" ON "OSMS"."DM_DATA_FILE_2"("FILE_NAME" ASC) STORAGE(ON "MAIN", CLUSTERBTR) ;
CREATE INDEX "IDX_FILE_PATH_2" ON "OSMS"."DM_DATA_FILE_2"("FILE_PATH" ASC) STORAGE(ON "MAIN", CLUSTERBTR) ;
CREATE INDEX "IDX_FILE_PID_2" ON "OSMS"."DM_DATA_FILE_2"("FILE_PID" ASC) STORAGE(ON "MAIN", CLUSTERBTR) ;
CREATE INDEX "IDX_POOL_ID_2" ON "OSMS"."DM_DATA_FILE_2"("POOL_ID" ASC) STORAGE(ON "MAIN", CLUSTERBTR) ;

总共1个语句正依次执行...

[执行语句1]:
SELECT * FROM DM_DATA_FILE_2 ORDER BY file_type limit 20
执行成功, 执行耗时1秒 615毫秒. 执行号:37125

1条语句执行成功

总共1个语句正依次执行...

[执行语句1]:
SELECT * FROM DM_DATA_FILE_2 WHERE file_pid = 51134 ORDER BY file_type limit 20
执行成功, 执行耗时8秒 499毫秒. 执行号:37124

1条语句执行成功