February 15, 2010 at 1:32 am
Hello All,
If I am implementing partitions on a very large table, and the table has indexes. Is the index content divided amongst the partitions the same was as the data? if not, how is it stored?
How is the behavior of Full Text Index different from Relational Index. Are they stored in one monolithic file, or the full text index also split along with the data into partitions?
February 15, 2010 at 2:25 am
SQL-Student (2/15/2010)
Hello All,If I am implementing partitions on a very large table, and the table has indexes. Is the index content divided amongst the partitions the same was as the data? if not, how is it stored?
You might find Craig Freedman's post useful, as well as the links provided in MSDN's Partitioned Table and Index Concepts.
How is the behavior of Full Text Index different from Relational Index. Are they stored in one monolithic file, or the full text index also split along with the data into partitions?
There's a very good whitepaper on Full Text Search here as well as a good section of information here.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply