Query lento
Saludos "Foristas"
tengo 3 tablas InnoDB en Mysql 5.0.27
todas tiene como campo index=>>ID varchar[20] NOT NULL
[Tabla-1]
filas=>128.000
index=>10MB
[Tabla-2]
filas=>657.000
index=>21MB
[Table-3]
filas=>702.000
index=>34MB
tengo un query donde las uno las 3 por un join
Select Tabla-1.ID
FROM Tabla-1 force index (Tabla-1.Status) LEFT JOIN (Tabla-2,Tabla-3) ON
(Tabla-1.ID=Tabla-3.ID and Tabla-1.ID=Tabla-2.ID )
WHERE Tabla-3.campoX>0 AND Tabla-1.type="01" and Tabla-1.Status="A"
esta consulta se me tarda de 45-50segs para darme un resultado de 15.000 filas
quisiera saber si puedo bajar el tiempo de velocidad por lo menos a la mitad.
gracias
Subject
Views
Written By
Posted
Query lento
4155
September 05, 2007 01:45PM
2436
September 06, 2007 02:45PM
2958
September 11, 2007 09:21AM
2857
September 13, 2007 07:42AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.