Thread: ...

...

From
Michael Fork
Date:
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



Re:

From
JanWieck@t-online.de (Jan Wieck)
Date:
Michael Fork wrote:
> 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);
> 
   Hmmm - not sure what that should tell us ?!?


> 
> Michael Fork - CCNA - MCP - A+
> Network Support - Toledo Internet Access - Toledo Ohio
> 


Jan

-- 

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #