RE: Index Field

2003-07-25 Thread Jim Smith
> Just a quick question on whether I need both fields to > be indexed. > > The table is as below.. I'm wondering if I need to have these > 2 fields -> > fa_id & serial_no > > fa_id would be a 7 character int like "001", "002" > serial_no would be like "WMACK001", "WMACM121" >

Index Field

2003-07-24 Thread Ow Mun Heng
Hi All, Just a quick question on whether I need both fields to be indexed. The table is as below.. I'm wondering if I need to have these 2 fields -> fa_id & serial_no fa_id would be a 7 character int like "001", "002" serial_no would be like "WMACK001", "WMACM121" most o