Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Adam Douglas writes:
>> Another thing that happens is when I tried to ALTER PostalCodeInfo and
>> PostalCodeReps table schemas MySQL seemed to be hung and put the CPU usage
>> at 99.0% to 99.02% (never ending it see
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Adam Douglas writes:
Sinisa>
>>
>> Alright, but is there no way then to decrease my query time of 14 seconds
>> (includes 3 queries) to something more reasonable for use on-line? 10
>> seconds according to stats is t
Adam Douglas writes:
> Ahh what do you mean "all tables are not related with common columns"? They
> are not suppose to be related with a common columns. PostalCodeInfo and
> Company table are completely two different things.
>
> Yes that is correct, I've resolved the issue with PostalCodeInfo fo
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Adam Douglas writes:
>> I'm running MySQL v3.22.32. Here's my problem I run the following
>> select query and both CompanyRep and PostalCodeInfo tables are not
>> using my Indexing. Why? How can I get these two tables
> Adam Douglas writes:
> > Correct 6 tables are being joined. Here's the explain of
> the query below
> > (btw, I'm not getting a index on CompanyShipInfo and
> PostalCodeInfo not
> > CompanyRep like I previous said). Excuse me if this seems
> dumb but I'm not
> > sure what you are saying in th
Adam Douglas writes:
> Correct 6 tables are being joined. Here's the explain of the query below
> (btw, I'm not getting a index on CompanyShipInfo and PostalCodeInfo not
> CompanyRep like I previous said). Excuse me if this seems dumb but I'm not
> sure what you are saying in the last two comments
> -Original Message-
> From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 31, 2001 1:27 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: Query Not Using Indexing
>
>
> Adam Douglas writes:
> > I'm running M
Adam Douglas writes:
> I'm running MySQL v3.22.32. Here's my problem I run the following
> select query and both CompanyRep and PostalCodeInfo tables are not
> using my Indexing. Why? How can I get these two tables to use indexing
> to speed up my query. You can look at my indexing on the two tabl
Adam Douglas writes:
> I'm running MySQL v3.22.32. Here's my problem I run the following
> select query and both CompanyRep and PostalCodeInfo tables are not
> using my Indexing. Why? How can I get these two tables to use indexing
> to speed up my query. You can look at my indexing on the two tabl
