Re: [NTISP] Calls Table - Index

John Lange ( radadmin@palacenet.net )
Fri, 28 Jan 2000 16:36:28 -0600

THANKS - Is this what I need to do??? Hurry, without the primary key my
server is running 45% utilization...

alter table calls add CONSTRAINT pk_Calls PRIMARY KEY (AcctSessionID,
NASIdentifier, NASPort, AcctStatusType)

JOhn :}

At 01:58 PM 1/28/2000 -0800, you wrote:
>John Lange wrote:
> >
> > HI
> >
> > Some years ago I had an SQL script that created a non / ? Clustered Index
> > for the calls table.
> >
> > I just re-created my calls table, and find that there are NO Key fields in
> > the table displayed in the EM.
> >
> > Should these be clustered, non-clustered? Dale sent me a script for this
> > several years ago, and I cannot find it now.
>
>The primary key is defined in insttabs.sql. The indexes are defined in
>instindx.sql. If you didn't use those scripts to create the table,
>then you will need to manually apply the Primary key, and run the
>section in instindx.sql to add the indexes.
>
>
>--
>
>Dale E. Reed Jr. Emerald and RadiusNT
>__________________________________________
>IEA Software, Inc. www.iea-software.com
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart

----- Whatever you do, work at it with all your heart, as working for the
Lord, not for men >Colossians 3:23 (NIV)

John C. Lange, Sr. PALACE dot NET, INC.
microjl@palacenet.net MICRO-TECH Computers, Inc.
608.742.1601 & 6980 1819 New Pinery Road
http://www.palacenet.net/ Portage, WI 53901
MSCE Training for only $150.00 - http://dpec.palacenet.net/
All 200+ Web Based Courses for $150.00 Per Year - "Really"

--- __o
--- _-\<,_ Fastest Service in Town
--- (_)/ (_)

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart