sql优化

SQL优化：

今天优化一段代码

SELECT IM2.MESSAGE_ID,
        IM2.SPOKEN_MAN,
        IM2.SEND_TIME,
        IM2.MESSAGE_CONTENT,
        IM2.TYPE,
        IM2.OBJECT_ID,
        IM2.TIME_STAMP,
        IM2.SESSION_ID,
        IM2.ORDER_ID,
        IM2.LETTER_ID,
        IM2.READ_USERS,
        IM2.UNREAD_USERS,
        IM2.TAG,
        IM2.ES_ID,
        IM2.WITHDRAW
   FROM IM_MESSAGE IM2
   JOIN IM_PROFESSOR_GROUP IPG
     ON IM2.SESSION_ID = IPG.SESSION_ID
  WHERE IPG.GROUP_ID = 255118

---

优化前：

IM_MESSAGE有大概有一千六百万条数据
IM_PROFESSOR_GROUP有大概六百条数据

优化前大概花费2.1s

---

优化：

对两个表的SESSION_ID加索引

优化后大概花费0.23s