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.
| Author |
Topic |
|
AskSQLTeam
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.
Thanks,
Andrew" |
|
|
|
|
|
Narrow search