Re: [GENERAL] generic sql question

2004-10-20 Thread Hicham G. Elmongui
i do no think writing the query in the second form differs from the first one. In both cases, only the relevent articles (in range and of desired type) will come out of the scan operator that scans the articles. --h "Dennis Gearon" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > My

[GENERAL] generic sql question

2004-10-20 Thread Dennis Gearon
My question is it possible to speed up a query doing preselects? What I'm working on could end up being a very large dataset. I hope to have 100-1000 queries per second (0r more?), and if very large tables are joined with very large tables, I imagine that the memory would be get very full, overf