Query is slowest, why it works always with the index
This is a discussion on Query is slowest, why it works always with the index within the MySQL forums, part of the Database Server Software category; --> I have a query that it orders to me for date, and is fastest. Then in an other query ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 07:30 AM
| ||||
| ||||
 Query is slowest, why it works always with the index I have a query that it orders to me for date, and is fastest. Then in an other query I must order for an other field (char (3)) and is slowest, why it works always with the index of the date why in the WHERE there is the condition for the date. How I can make in order to velocizzare the query? Thanks!      |
|
02-28-2008, 07:30 AM
| ||||
| ||||
| Re: Query is slowest, why it works always with the index andrea.zac@libero.it wrote: > I have a query that it orders to me for date, and is fastest. Then in > an other query I must order for an other field (char (3)) and is > slowest, why it works always with the index of the date why in the > WHERE there is the condition for the date. How I can make in order to > velocizzare the query? Thanks! > Andrea, Without knowing the table structure, which indexes are available and the queries you're using, it would be impossible to provide a meaningful answer to your question. -- ================== Remove the "x" from my email address Jerry Stuckle JDS Computer Training Corp. jstucklex@attglobal.net ================== |
Linear Mode
