SQL SERVER View SQL statement IO, time, index consumption

1. View SQL statement IO consumption

SET STATISTICS IO on
SELECT * from Dbo.jx_order where order_time> ' 2011-04-12 12:49:57.580 '
SET STATISTICS IO off

2. View the SQL statement time consumption

SET STATISTICS time on
SELECT * from Dbo.jx_order where order_time> ' 2011-04-12 12:49:57.580 '
Set STATISTICS time off

3. View SQL Statement Index consumption

Set STATISTICS PROFILE on
SELECT * FROM Dbo.jx_order
where order_time> ' 2011-04-12 12:49:57.580 '
Set STATISTICS profile off

The red box in this can see that this query has gone through a clustered index scan