What are the recommendations for index compression in the following
index types:


1. Guid as primary index
2. Guid as foriegn key index
3. Varchar, not unique, such as customer name, address etc
4. integer field primary index
5. integer field, foriegn key
5  SmallInt field, not unique

I have read the docs but want to make sure i am applying that info
correctly.  This app will be C/S with both LAN and WAN connections.

Thanks



--
David Farrell-Garcia
Whidbey Island Software, LLC

David,

<< 1. Guid as primary index >>

Duplicate-byte.

<< 2. Guid as foriegn key index >>

Same.

<< 3. Varchar, not unique, such as customer name, address etc >>

Full, especially if there is a lot of blank space.

<< 4. integer field primary index >>

None.

<< 5. integer field, foriegn key >>

Duplicate-byte, although None might do just as well or better depending upon
the actual index keys.

<< 5  SmallInt field, not unique >>

None.  Don't ever try to compress anything smaller than 4 bytes (Integer).

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

> David,.......



Thx Tim.  I guess I was on the right track.



--
David Farrell-Garcia
Whidbey Island Software, LLC