CREATE INDEX idx_radacct_1 ON radacct (username,acctstatustype,tstamp);
CREATE INDEX idx_radacct_2 ON radacct (username,acctstatustype);
CREATE INDEX idx_radacct_3 ON radacct (username,tstamp);
CREATE INDEX idx_radacct_4 ON radacct (acctstatustype,tstamp);
CREATE INDEX idx_radacct_5 ON radacct (tstamp);
CREATE INDEX idx_radacct_6 ON radacct (acctstatustype);
CREATE INDEX idx_radacct_7 ON radacct (username);
CREATE INDEX idx_radacct_8 ON radacct (tstamp,acctstatustype);
Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toledo Ohio