homebrew01 (9/28/2016)
The thinking was a denormalized flat file, with indexed columns would give fast search results.
Have you tested that thinking out and confirmed it? If not, do some tests before you put a pile of work in.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability