RE: Query Not Using Indexing

2001-08-05 Thread Michael Widenius
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

RE: Query Not Using Indexing

2001-08-05 Thread Michael Widenius
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

RE: Query Not Using Indexing

2001-08-04 Thread Sinisa Milivojevic
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

Re: Query Not Using Indexing

2001-08-03 Thread Michael Widenius
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

RE: Query Not Using Indexing

2001-08-01 Thread Adam Douglas
> 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

RE: Query Not Using Indexing

2001-08-01 Thread Sinisa Milivojevic
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

RE: Query Not Using Indexing

2001-07-31 Thread Adam Douglas
> -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

Re: Query Not Using Indexing

2001-07-31 Thread Sinisa Milivojevic
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

Re: Query Not Using Indexing

2001-07-31 Thread Sinisa Milivojevic
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

Query Not Using Indexing

2001-07-31 Thread Adam Douglas
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 tables below the query. Any help