Eric,
Can you send us the actual show indexes from table and explain output that
isn't shortend?
Thank you for answer my question.
Actually, the real query and tables are much more complex than
the data in the previous message.
A just tryed to optimize the information for you better
Hello,
I´m using MySQL-4.1.7, and I have a query that seems,
even using where clause, an specific table isn´t being optimized
properly:
I have four tables:
real_state: cod, name, city, ag_cod, sell
agency: cod, name, ag_status
front: cod, rs_cod, ag_cod
photo: cod, rs_cod
These table have the
Can you send us the actual show indexes from table and explain output
that isn't shortend?
Ronan Lucio wrote:
Hello,
I´m using MySQL-4.1.7, and I have a query that seems,
even using where clause, an specific table isn´t being optimized
properly:
I have four tables:
real_state: cod, name,
Hello,
Supposing I have 2 tables:
product
==
- id
- name
price
=
- id
- product_id
- sell_price
- rent_price
If I want to make a SELECT for the products having the
rent_price between 300,00 and 500,00, so I use the query:
SELECT rent_price
FROM product
LEFT JOIN price ON (product.id =