From: "Antti Kurenniemi" 

"Ad"  wrote in
message news:45535737{at}w3.nls.net...
>
>> So, my quesstimate would be somewhere between "very
little" and "dick
>> all".
>>
>
> Yup, the "table scan" is the killer.
>
> indexing is the biggest perf gain you can do. I have worked on numerous
> db'es which had no keys (fk or pk) & only had indexes.

Often it seems that at application level, programmers are pretty clueless
as to how databases work. "Indexing? We don't need no steenkin'
indexing, we just pull the data and handle it in our application - sort it
there and then process only what we're interested in. Whaddya mean what
happens when there is three gigabytes of data and users behind 512 k
adsl?"


Antti Kurenniemi

--- BBBS/NT v4.01 Flag-5