Hi,

I've got a table "EmpCalendar" that has a primary key on two fields: EmpNo,CalDate.
Doing a select with
where EmpNo = <value> and CalDate = <value>
uses the primary key - correct?
As does a select with
where EmpNo = <value>
- still correct?

Should I create an additional index on CalDate, if I do frequent queries
with
where CalDate = <value>
?
TIA

_____________________________________

Lutz Kutscher
Pattburg Poetzsch GmbH & Co KG
Tel. +49 461 773 15 60
Fax +49 461 773 15 15
LKutscher@...