performance question

Hi,

I have a situation where any design or other suggestions are appreciated.

I have more than half a million data files with 300K each. Each file is one record with a binary data section of around 7K that I am interested in. I'll need to do query on that particular binary data section in that huge table of data record, such as 'SELECT * FROM MyHugeTable WHERE ColumnName='MyBinaryColumn'. Are there suggestions (table design, query and others) that may help to improve the performance?

Thanks a lot,

Alex Received on Tue Mar 23 2004 - 19:49:24 CST