He Shiming <[EMAIL PROTECTED]> wrote:
select * from hvh5m,itm where hvh5m.Column4=itm.Icol1 order by
Column8
You can try creating two additional indexes, one on hvh5m.Column4 and
the other on hvh5m.Column8. They should speed things up.
Actually, what would help here is a compound index on (Column4, Column8)
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
