Posted by Ed Murphy on 11/05/07 04:54

Analizer1 wrote:

> i need to search a table for columns
> i have to match data i recieve from a online transaction batch
> example
> in our system we send out
> transactionno (unique)
> Acctno (can be duplicated in transfile)
> insuredacct (can be duplicated)
> firstname (can be duplicated)
> lastname (can be duplicated)
> datofbirth (possible with the above duplicated)
> transdate (not possible to be duplicated with the above)
>
> we have a table with all completed transactions (few million)
>
> I need to match the above to a transaction so i can report to the entity who
> transmited the data to our company
> the company we transmit to send back the above information..without the
> transaction number
>
> based on the above what is the best way to match to the correct row and how
> should i build a index based on the above

Educated guess:

create unique clustered index index1 on the_table (transactionno)

create unique index index2 on the_table (acctno, insureacct,
firstname, lastname, datofbirth, transdate)

[Back to original message]