I have a database with over 3,000,000 rows, each has an id and xml field with varchar(6000).

If I do `SELECT id FROM bigtable` it takes +- 2 minutes to complete. Is there any way to get this in 30 seconds?