October 3, 2014 at 7:56 am
hi,
i'm trying to work with full text search , i have create a view , but unfortunately , the view doesn't have a column which have a non duplicate data to use it for creating the "unique clustered index".
anyone have any idea. thx in advance
October 4, 2014 at 4:02 am
h2sh (10/3/2014)
hi,i'm trying to work with full text search , i have create a view , but unfortunately , the view doesn't have a column which have a non duplicate data to use it for creating the "unique clustered index".
anyone have any idea. thx in advance
Quick question, do you have a combination of columns that form a unique key? If not I would suggest a redesign.
😎
October 4, 2014 at 7:55 am
thx for your quick replay.
Even if i have a combination of columns that form a unique key , this will not help me because to work with full text search you should have a "unique" column which form a unique key.
i will give you an example : i have 3 tables : Content , music and track. the tables content Can have multiples track , and also multiples music .track can have only one content and music also can have only one content.
if you create a view for these tables you will never have a column that form a unique key
i have to work with full text search . what i should do ?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply