讨论如何优化这条sql

  SELECT *
             FROM (SELECT ROWNUM ROWSEQ, SQLA.*
                     FROM (SELECT *
                             FROM QMYS_V_ZLCS
                            WHERE 1 = 1
                              AND SPZT IN ('A', 'B', 'C', 'D')
                           ) SQLA)
            WHERE ROWSEQ BETWEEN 1 AND 15 ORDER BY QMYS_ZLCS_ID desc

哪位可以优化一下？谢谢！