jive_forums_4_oracle_extra_stats_indexes.sql

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

/*
 * $RCSfile$
 * $Revision: 16985 $
 * $Date: 2005-07-29 17:17:44 -0700 (Fri, 29 Jul 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 jiveHRSS_IP_idx ON jiveHTTPReadStatSession (IP);
CREATE INDEX jiveHRSS_country_idx ON jiveHTTPReadStatSession (country);

CREATE INDEX jiveNRSS_IP_idx ON jiveNNTPReadStatSession (IP);
CREATE INDEX jiveNRSS_country_idx ON jiveNNTPReadStatSession (country);

CREATE INDEX jiveMessage_combo_idx ON JiveMessage (messageID, modificationDate, forumID, modValue);