From: Adam <""4thwormcastfromthemolehill\"{at}the field.near
the bridge">

Antti Kurenniemi wrote:
> "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?"
>
>
Oh indeed. Most seem to think pk'es are the only indexes a db needs. Then
ask em what their questions are & how often they end with "where
id
=" ...."oh no we most often quiz the customer db by last name, the
clients db by cust_name...etc.etc."

Slap.


Adam

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