SQLSERVER中忽略索引提示

SELECT id,name from TB with (index(IX_xttrace_bal)) where bal<100

USE master
GO
IF DB_ID('Trace8602') IS NOT NULL
    DROP DATABASE Trace8602
GO
CREATE DATABASE Trace8602
GO
USE Trace8602
GO
CREATE TABLE xttrace8602
    (
      id INT IDENTITY(1, 1)
             PRIMARY KEY ,
      bal INT ,
      name VARCHAR(100)
    )
GO
CREATE NONCLUSTERED INDEX IX_xttrace8602_bal_name ON xttrace8602(bal,name)
GO
CREATE NONCLUSTERED INDEX IX_xttrace8602_bal ON xttrace8602(bal)
GO
INSERT  INTO xttrace8602
VALUES  ( RAND() 786, 'blogs./lyhabc' )
GO 10000
CREATE PROC uspFirst
AS
    SELECT  id ,
            name
    FROM    xttrace8602 TF WITH ( INDEX ( IX_xttrace8602_bal ) )
    WHERE   bal < 100
GO

--没有使用跟踪标致
EXEC uspFirst 
GO

--使用了跟踪标志
DBCC TRACEON(8602,-1)
GO
DBCC FREEPROCCACHE
GO
EXEC uspFirst
GO