???????????????????м???????
---?????????????м??
DECLARE @DBID INT
SET @DBID=DB_ID()
DBCC FLUSHPROCINDB(@DBID);
GO
---?????????????
CREATE TABLE TPlan
(ID INT PRIMARY KEY IDENTITY(1??1)??
Name NVARCHAR(20) NOT NULL??
Istate INT NOT NULL??
Idate DATETIME DEFAULT(GETDATE())
)
GO
---????????
CREATE INDEX IX_TPlan_NAME ON TPlan
(Name
)
GO
INSERT INTO TPlan(Name??Istate)
VALUES('1'??1)??('2'??2)??('3'??3)
GO
SELECT NAME FROM TPlan
GO
SELECT Cacheobjtype??objtype??dbid??objid??usecounts??pagesused??sql FROM sys.syscacheobjects
WHERE DBID=DB_ID()

???????Profiler???
???????SQL:StmtRecompile???????????洢??????????SP:Recompile

???????????
??????????????????
????DROP INDEX [IX_TPlan_NAME] ON [dbo].[TPlan] WITH ( ONLINE = OFF )
????GO
????USE [Study]
????GO
????CREATE NONCLUSTERED INDEX [IX_TPlan_NAME] ON [dbo].[TPlan]
????(
????[Name] ASC
????)
????INCLUDE ( [Istate]) WITH (PAD_INDEX  = OFF?? STATISTICS_NORECOMPUTE  = OFF?? SORT_IN_TEMPDB = OFF?? IGNORE_DUP_KEY = OFF?? DROP_EXISTING = OFF?? ONLINE = OFF?? ALLOW_ROW_LOCKS  = ON?? ALLOW_PAGE_LOCKS  = ON?? FILLFACTOR = 90) ON [PRIMARY]
????GO
????????в??
????SELECT NAME FROM TPlan

??????????????ζ???м???????
??????????????????
????ALTER TABLE [dbo].[TPlan]
????ADD Number INT

???????????й????????????????м???????????????????????
????????м??
????SELECT Cacheobjtype??objtype??dbid??objid??usecounts??pagesused??sql FROM sys.syscacheobjects
????WHERE DBID=DB_ID()

??????м????????????м?????????????Σ????????????д????????±????μ???м?????????????????????????????1????

?????2?SQL Server????????????????????м?????????????м??????????????????μ????л???????????β??????м????
?????????????????鷳?????
???????
???????????????а?????????????????????лл??????