--drop table test_table
SELECT object_id, name, system_type_id INTO test_table FROM master.sys.all_parameters

CREATE NONCLUSTERED INDEX ix_name ON test_table (name ASC)

ALTER TABLE test_table ADD name_REVERSED AS REVERSE(name)


PRINT '========== Insert with no index =========='
SET STATISTICS IO ON
SET STATISTICS TIME ON
INSERT INTO test_table SELECT 1,'Dodah',2
SET STATISTICS TIME OFF
SET STATISTICS IO OFF
GO
CREATE NONCLUSTERED INDEX IX_REVERSED ON TEST_TABLE (NAME_REVERSED ASC) INCLUDE (NAME)
GO
PRINT '========== Insert with index =========='
SET STATISTICS IO ON
SET STATISTICS TIME ON
INSERT INTO test_table SELECT 1,'Dodah',2
SET STATISTICS TIME OFF
SET STATISTICS IO OFF

(6756 row(s) affected)
========== Insert with no index ==========
SQL Server parse and compile time: 
   CPU time = 0 ms, elapsed time = 0 ms.
SQL Server parse and compile time: 
   CPU time = 0 ms, elapsed time = 0 ms.
Table 'test_table'. Scan count 0, logical reads 3, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

SQL Server Execution Times:
   CPU time = 0 ms,  elapsed time = 1 ms.

(1 row(s) affected)
========== Insert with index ==========
SQL Server parse and compile time: 
   CPU time = 0 ms, elapsed time = 0 ms.
SQL Server parse and compile time: 
   CPU time = 0 ms, elapsed time = 0 ms.
SQL Server parse and compile time: 
   CPU time = 0 ms, elapsed time = 0 ms.
Table 'test_table'. Scan count 0, logical reads 11, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

SQL Server Execution Times:
   CPU time = 0 ms,  elapsed time = 1 ms.

(1 row(s) affected)