Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Community Discussions (All other subjects)
 Full-Text Indexing on FORUM_TOPICS
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

redbrad0
Advanced Member

USA
3725 Posts

Posted - 15 January 2005 :  23:43:37  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
I have tried to add full-text indexing on one of the database's on my sql server. When I right click on the FORUM_TOPICS table select Full-Text Index Table --> Define Full-Text Indexing on a Table then I get the following error message.

The selected table has no unique single column index on a column that does not allow NULLS

I can seem to find anything that is wrong on the table that would not allow me to add this. Anyone have any ideas?

Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets

redbrad0
Advanced Member

USA
3725 Posts

Posted - 16 January 2005 :  00:18:15  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
Nevermind I figured it out. I had to create a index/key for each table.

Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets
Go to Top of Page

fetch
Starting Member

46 Posts

Posted - 09 May 2005 :  23:29:48  Show Profile  Visit fetch's Homepage
Can you elaborate on how you got full text indexing to work? I.e. how did you create an index/key for each table? I'm getting timeouts when I try and do an update Forum count and I think this will help dramatically.

http://www.mhsaa.org/4rum/forum/
Go to Top of Page

pdrg
Support Moderator

United Kingdom
2897 Posts

Posted - 10 May 2005 :  05:46:20  Show Profile  Send pdrg a Yahoo! Message
fulltext engine requires a distinct single-column key to return a set of matches (and their ranks) - I don't think it'd help you with the forum count per se...

what kind of numbers are you talking about - a few thousand, a few million or a few billion? there may be indexing optimisations you can make, or there may be other blocks...
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.29 seconds. Powered By: Snitz Forums 2000 Version 3.4.07