jive_forums_4_mysql_extra_stats_indexes.sql

来自「Jive Forums 论坛源码 v4.2.3」· SQL 代码 · 共 23 行

#
# $RCSfile$
# $Revision: 16739 $
# $Date: 2005-06-29 17:52:40 -0700 (Wed, 29 Jun 2005) $
# Copyright (C) 1999-2005 Jive Software. All rights reserved.
# This software is the proprietary information of Jive Software. Use is subject to license terms.
#
# Optional read stat indexes.
#
# The following SQL commands create new indexes on the jiveReadStat table. These are
# not required indexes but can help stats performance.
#

CREATE INDEX jiveReadStat_userID_idx ON jiveReadStat(userID);
CREATE INDEX jiveReadStat_objectType_idx ON jiveReadStat(objectType);
CREATE INDEX jiveReadStat_objectID_idx ON jiveReadStat(objectID);
CREATE INDEX jiveReadStat_sessionID_idx ON jiveReadStat(sessionID);

CREATE INDEX jiveHTTPRSS_IP_idx on jiveHTTPReadStatSession(IP);
CREATE INDEX jiveHTTPRSS_country_idx on jiveHTTPReadStatSession(country);

CREATE INDEX jiveNNTPRSS_IP_idx on jiveNNTPReadStatSession(IP);
CREATE INDEX jiveNNTPRSS_country_idx on jiveNNTPReadStatSession(country);