Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Single-column index a must???

Status
Not open for further replies.

Abhi2000

Programmer
Joined
Jun 6, 2007
Messages
1
Location
IN
Hello,

I have a query about full-text search feature of MS SQL
Server 2000. According to MSDN - "The principal design
requirement for full-text indexing, querying, and
synchronization is the presence of a full-text unique key
column (or single-column primary key) on all tables that
are registered for full-text search".
Now my question is -

1) What is this index needed for?

2) In my database design, the table I want to create full-
text index on has a composite primary key spanning 3
columns. How can I do full-text search on a text field in
this table? I cannot change the database design now to create a single column primary key.

Thanks in advance,
- Abhi.
 
Don't know anything about full-text search function, but
I know that

a UNIQUE constraint is not the same thing as a PRIMARY KEY constraint. A table can have only one PRIMARY KEY, but it can have several UNIQUE constraints. A UNIQUE CONSTRAINT can be defined for one column or for a combination of columns.

Also I think that an index is automatically created for a UNIQUE constraint, and that would be very helpful when searching.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top