Re: Newbie question:why use stack in Full-Text index?

It may not be the best for searching and returning a single value, or
seeking, or scanning, but it is best for the type of proximity searches;
i.e. a search on "George Bush" has to return all rows where George is
immediately followed by Bush.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"fumade" <fumade@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C011C00E-B504-4137-8E0F-46B60858EC30@xxxxxxxxxxxxxxxx
Howdy,

The following is quoted from book online:

Instead of constructing a B-tree structure based on a value stored in a
particular row, MSFTESQL builds an inverted, stacked, compressed index
structure based on individual tokens from the text being indexed.



What confused me is that stack, as a data structure, is not a good option
for searching.

So why it uses stack, will it hurt the performance?



Thanks in advance.



.

Relevant Pages

  • Re: wm2003 standard SDK Bluetooth query
    ... then found I was searching in the wrong group. ... Brett ... > stack. ... > Peter Foot ...
    (microsoft.public.pocketpc.developer)
  • Re: Re: 3COM TFTPD Overflow: SEH Overwrite
    ... Regarding the return address...I already have control of EIP, but can't point it directly to the stack, so I'm searching for a module with a suitable return address to help me get back to that buffer. ...
    (Vuln-Dev)
  • Re: FOAK: Wii
    ... searching now. ... Are they really as rare as rocking horse shit or am I ... I'm sure I saw a stack of them in the local HMV recently. ...
    (uk.rec.motorcycles)
  • Re: How to locate compiled binary code relative to source code?
    ... >> Pop register A from stack ... > Just as an extension to that, to aid in searching and so on, how about ...
    (comp.programming)
  • Re: Newbie question:why use stack in Full-Text index?
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ... What confused me is that stack, as a data structure, is not a good option ...
    (microsoft.public.sqlserver.fulltext)
Loading