RE: Indexing an SQL view

[qsrvbas@xxxxxxxxxxxx (Tom Liotta)]

Vern:

Well, rats. I was actually feeling intrigued at learning something new. Now I 
have to go back and re-read that whole set of posts about the query 
optimizer(s?) and the use of SQL INDEX vs. keyed LFs. We ought to be getting 
closer to this being a science, but it keeps feeling more like an art.

Tom Liotta

"The more things change, the more they remain insane."
 -- Johnny Carson


midrange-l-request@xxxxxxxxxxxx wrote:

>   8. RE: Indexing an SQL view (Vern Hamberg)
>
>I may have not been clear enough - the index is actually the LF itself -
>key fields (K-specs) over the new calculated fields. An SQL index cannot be
>created over an LF, as I just checked.
>
>But this is what we tools vendors are about, right? Selling things that
>help people manage the increasingly unmanageable.
>
>At 10:02 PM 4/19/2004 -0400, you wrote:
>>
>> >Fortunately, Rick reports improvement.   ;-)
>>
>>Yes, 'fortunately'. From some of the threads recently, I'm getting the
>>feeling that educated DB2 DBAs are becoming more important. It seems that
>>few are willing to assert "THIS is how it should work." As much as I
>>recognize that environment significantly changes results, revelations such
>>as the need for SQL INDEXes rather than keyed LFs seem to come out of
>>nowhere. (Surprise!)
>>
>>A DBA supposedly could keep up. But generalist programmers have far too
>>much in too many areas to keep up with. I've long been aware that SQL
>>VIEWs over other VIEWs and even over LFs let you do some pretty slick
>>stuff. But it never occurred to me to INDEX a LF -- much less grasp the
>>implications if there are any.

-- 
Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone  253-872-7788 x313
Fax    253-872-7904
http://www.powertech.com


__________________________________________________________________
Introducing the New Netscape Internet Service. 
Only $9.95 a month -- Sign up today at http://isp.netscape.com/register

Netscape. Just the Net You Need. 

New! Netscape Toolbar for Internet Explorer
Search from anywhere on the Web and block those annoying pop-ups.
Download now at http://channels.netscape.com/ns/search/install.jsp