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

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Narrow search

Author  Topic 

Ask SQLTeam Question

0 Posts

Posted - 2000-12-06 : 09:27:34
Andrzej writes "I am wondering how the narrow search functionality should work for huge database content.

Right now, I have only two solutions in my mind:

1. After each subquery add some filter string to SQL statement
and execute query once again
2. Create temporary table to store information from previous
query and search in the resultset

However, I think that both solutions are wrong, because:

1. This solution causes creating longer query which affects the
same set of rows every time. It is going to take a lot of
time for huge table content.
Besides, SQL Server has limited length of the query string

2. If the first resulstet is saved then the huge amount of rows
may be added to temporary table... It can take forever...

I would very appreciate any response if you have an idea, how to do the efficient narrow searching for big tables.


- Advertisement -