If you've got a database with 200 million records then you might also want to think about 'horizontally partioning' your table. That'll have a significant impact on performance - especially if you store each partition on a separate box...