Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Index files Created during Free Text Search

Author  Topic 

ezhil
Starting Member

9 Posts

Posted - 2008-03-08 : 00:01:18

history.ix, index_a.ix, index_d_1.ix, index_di_1.ix, index_i_2.ix,
index_k_2.ix, index_kl_1.ix, index_klh_2.ix, index_n.ix,
index_r_l.ix, index_sv.ix, index_v.ix, index_v_ix.log, indexlog.dat.

This index files are created in my hidden folder. Now, my problem is,
1) Is this files associated with Full Text Search.
2) when the file will be created.
3) For what purpose, this files are stored.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-08 : 01:44:42
1. yes.
2. when you create full text category.
3. for full text search.
Go to Top of Page

ezhil
Starting Member

9 Posts

Posted - 2008-03-08 : 01:56:49
1) Can we referrence this files directly
2) Where it will be located in our system?
3) is it loaded for each Full Text Index we created for the table.
4) How this file are used in Full Text Search.
Go to Top of Page

dataguru1971
Master Smack Fu Yak Hacker

1464 Posts

Posted - 2008-03-08 : 11:45:46
I can't believe I missed one...did you post the same thing in every forum?
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=98661
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=98662
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=98663
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=98666

You don't have to post the same thing so many times ...




Poor planning on your part does not constitute an emergency on my part.

Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-08 : 15:03:56
1. don't think so.
2. you specify when create full text index category.
3. yes.
4. managed by ms search service.
Go to Top of Page
   

- Advertisement -