On 11/1/07, carter ck <carterck32(at)hotmail(dot)com> wrote:
>
> Hi all,
>
> Has anyone come across a solution for faster and powerful search stored procedure in a table that contains more than 500K of records?
>
> I am currently trying to work around with it. All helps are appreciated.
Are you using the tsearch2 full text engine? If not, you're missing
the boat for fast searching text. But you didn't really tell us what
exactly you're searching on, so I'm just guessing.