On Wed, Mar 14, 2001 at 05:36:00PM +1100, Leonard Coonan wrote:
>
> Further to your comment, I have had considerable benefits by
> creating an index of both keys as well. So I define 3 indexes
> userid, usernum, userid&usernum.
One of those is redundant.
If you index (userid, usernum) and then
Bob Silva
Cc: [EMAIL PROTECTED]
Subject: Re: Any ideas why this would happen
In the last episode (Mar 13), Bob Silva said:
> Hope this isnt a dupe post...I mailed before confirmation was
> received so I think my post died.
>
> Here is the issue I run the query below and it t
In the last episode (Mar 13), Bob Silva said:
> Hope this isnt a dupe post...I mailed before confirmation was
> received so I think my post died.
>
> Here is the issue I run the query below and it takes forever ( 1+
> minutes ). It uses 2 keys (one unique) in the where clause but still
> does a f
