关闭

semantic search

标签: semanticsearchui
248人阅读 评论(0) 收藏 举报
分类:

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


 

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:183083次
    • 积分:3388
    • 等级:
    • 排名:第9937名
    • 原创:154篇
    • 转载:0篇
    • 译文:3篇
    • 评论:30条
    文章分类
    最新评论