Re: Alternate keys.

From: Reinier <Reinier_Dickhout_at_hetnet.nl>
Date: Fri, 20 Oct 2000 08:11:27 +0200
Message-ID: <u2g$XzlOAHA.351@net003s>

Sangeetha,

What will be the main entry point for data-select. Will users search mainly on order number or also a lot on order date and order costs. If so then you should consider these alternate keys for indexing. Because that's the purpose if I read my memory well (it's been a long time since I took lessons in data-modelling).

Reinier.

<ssg_at_srasys.co.in> wrote in message news:8soibf$bar$1_at_nnrp1.deja.com...
> Hi..
>
> I am in the process of learning Data modeling and Data Designing. I
> would like to know how to identify an alternate key. To
> me any candiate key which is not selected to be a primary key is an
> alternate key. I have a sample table called as Order. It has Order No,
> Cust no, Order Date, Order Cost. Here Order No is the primary key.
> Customer No is the foreign key. Should I consider Order Date and Order
> Cosya as alternate keys? I request for some assistance.
>
> Bye
> Sangeetha
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Oct 20 2000 - 01:11:27 CDT