semantic search

创建语义索引：从无到有

最新推荐文章于 2025-03-18 10:01:59 发布

最新推荐文章于 2025-03-18 10:01:59 发布 · 167 阅读

本文介绍如何在没有全文索引的情况下创建语义索引，并提供了实例演示，包括创建唯一索引、全文索引和语义索引的方法，以及在已有全文索引上添加语义索引的操作。

Create a Semantic Index When There Is No Full-Text Index

Example 1: Create a unique index, full-text index, and semantic index

CREATE FULLTEXT CATALOG ft AS DEFAULT GO CREATE UNIQUE INDEX ui_ukJobCand ON HumanResources.JobCandidate(JobCandidateID) GO CREATE FULLTEXT INDEX ON HumanResources.JobCandidate (Resume Language 1033 Statistical_Semantics ) KEY INDEX JobCandidateID WITH STOPLIST = SYSTEM GO

Example 2: Create a full-text and semantic index on several columns with delayed index population

CREATE FULLTEXT CATALOG documents_catalog GO CREATE FULLTEXT INDEX ON Production.Document ( Title Language 1033, DocumentSummary Language 1033, Document TYPE COLUMN FileExtension Language 1033 Statistical_Semantics ) KEY INDEX PK_Document_DocumentID ON documents_catalog WITH CHANGE_TRACKING OFF, NO POPULATION GO

populate index

ALTER FULLTEXT INDEX ON Production.Document SET CHANGE_TRACKING AUTO GO

Create a Semantic Index When There Is an Existing Full-Text Index

ALTER FULLTEXT INDEX ON Production.Document ALTER COLUMN Document ADD Statistical_Semantics WITH NO POPULATION GO