SQL 2008 R2 Views
Posted on 2013-10-25
If I have a table with 25 fields, 350,000 records and i only want to process the records that have a 5 in the field called Number, what is best to do:
Build a view over the table only selecting the 5 records ?
Build a index over table (indexing Number field) ?
Other reports use the table and need to see the 5 records.