jive_forums_4_hsqldb_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 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);