Re: [SQL] primary key and indexing

2001-01-19 Thread Richard Huxton
Sorry for lack of proper quoting, you might find it useful to From: "Sharmad Naik" <[EMAIL PROTECTED]> I m sorry If anyone has already asked this Q earlier I wanted to know Q1. Whether I can have another key on which the table is indexed even though i have a primary key..Then how would the

[SQL] primary key and indexing

2001-01-19 Thread Sharmad Naik
I m sorry If anyone has already asked this Q earlier     I wanted to know   Q1. Whether I can have another key on which the table is indexed even though i have a primary key..Then how would the data be accessed according to primary key or the indexed key of my choice or i can index as per m