Re: [NTISP] Calls Table - Index

Dale E. Reed Jr. ( (no email) )
Fri, 28 Jan 2000 13:58:25 -0800

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