SqlServer 全文索引创建及测试

--	创立测试表
--	DROP TABLE FullTextIndexing
CREATE TABLE FullTextIndexing
(
	ID INT IDENTITY(1,1) NOT NULL,
	Sentence VARCHAR(MAX)
)

--	创立集合索引
ALTER TABLE FullTextIndexing ADD CONSTRAINT PK_FullTextIndexing PRIMARY KEY CLUSTERED(ID ASC)
GO

--	将"全文搜索概述"页面的文字全体拷贝到txt,然后倒入到表FullTextIndexing中
--	https://msdn.microsoft.com/zh-cn/library/ms142547(v=sql.105).aspx


--	反复15次,从47行变成154万行
INSERT INTO FullTextIndexing(Sentence)
SELECT Sentence FROM FullTextIndexing
GO 15


SELECT COUNT(*) FROM FullTextIndexing--	创立测试表
--	DROP TABLE FullTextIndexing
CREATE TA