最近接了个新需求，是开发对数据库表进行了索引的优化，拿到这个需求不太懂怎么去设计用例测试，大佬们是怎么测试的
这是其中的一段 sql

• "SELECT "
• " app_id AS appId, "
• " tool_type AS toolType,"
• " SUM(duration) AS dailyStartDuration "
• "FROM qt_test "
• "WHERE del = 0 "
• " AND app_id IN ( "
• " "
• " #{appId}"
• " ) "
• "AND created_time BETWEEN UNIX_TIMESTAMP(#{statDate}) AND UNIX_TIMESTAMP(#{statDate})+86399 "
• "GROUP BY app_id,tool_type"