jive_forums_4_sqlserver_extra_stats_indexes.sql

Jive Forums 论坛源码 v4.2.3

/*
 * $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);