Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Full-Text Search / November 2004

Tip: Looking for answers? Try searching our database.

Another Newbie questions

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ed - 30 Nov 2004 00:07 GMT
Hi,
 Do i need to populate the Full-Text catalog and Full-Text Index both in
order to get the most updated data??? I thougth all I need to do is to
populate the Full-Text Index, if so, what is the reason to populate the
catalog, too????
If I need to populate both, do i have to populate the catalog first, then
Index?
Thanks for any explaination
Ed
John Kane - 30 Nov 2004 05:40 GMT
Ed,
I guess the answer is both, but not because there are *two* objects, but
because often these terms are used interchangeable. See SQL Server 2000 BOL
(Books online) title "Full-Text Indexes" for more details on the differences
between "Full-text indexes" and "Regular SQL indexes" as well as BOL title
"Full-Text Catalogs and Indexes".

Specifically, you *populate* a FT Catalog via sp_fulltext_catalog
(start_full) as you can have more than one table per FT Catalog.  However,
you set "Change Tracking" and "Update Index in Background" at the
table-level via sp_fulltext_table (start_change_tracking).

Hope this helps!
John

> Hi,
>   Do i need to populate the Full-Text catalog and Full-Text Index both in
[quoted text clipped - 5 lines]
> Thanks for any explaination
> Ed
Hilary Cotter - 30 Nov 2004 12:23 GMT
A catalog may index one or more tables. If you are only indexing one table,
it makes no difference when you run a full population on the catalog or on
the index.

If you are indexing multiple tables, you should run a full popluation on a
table basis for performance reasons. In other words, it will be faster and
you will get better performance when run populations on a per table basis.

In general you should place index each table its own catalog as MSSearch
(the engine which does the indexing) allocates threads on a per catalog
basis. So the more catalogs you have the more threads there will be
servicing your indexing and querying processes. However, there will be
greater overheard with the larger number of threads and catalogs.

Even so if you are indexing large tables you can get performance increases
by splitting the table up into pieces/child table (this process is called
partitioning) and having a seperate catalog for each child table.

Signature

Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html

> Hi,
>  Do i need to populate the Full-Text catalog and Full-Text Index both in
[quoted text clipped - 5 lines]
> Thanks for any explaination
> Ed
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.