-
Full text index: drop vs. disable
Hi,
I need to bcp records into tables with full text indexes. As I understand, it is a good idea to remove indexes prior to inserting records for performance reasons. All articles I've read about it mention dropping indexes and recreating them after a table is updated, but sp_fulltext_database allows to disable indexes without dropping them. Here is the description of the 'disable' option from MS site:
Removes all full-text catalogs in the file system for the current database and marks the database as being disabled for full-text indexing. This action does not change any full-text index metadata at the full-text catalog or table level.
Does anyone know what is the best way to remove indexes before bcp-ing data in?
Thanks in advance,
Yana
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|