Sajith A <[EMAIL PROTECTED]> wrote on 06/24/2005 02:07:22 AM:
> Thank you Mathias once again
> > I suggest you to test after optimize table ... and analyze table ...
> > if you stay with the problem and you can give me a set of data,
> i'll try to help
> > more.
> Initially while posting... i
Sajith A wrote:
Thank you Clark for your time
Try using straight joins to force MySQL to join from qb_test_result first.
The order chosen by the optimizer has no use for keys from this table.
I tried to force indexes.. but it didn't help
Thank you
Since the query you supplied cann
Thank you Clark for your time
> Try using straight joins to force MySQL to join from qb_test_result first.
> The order chosen by the optimizer has no use for keys from this table.
I tried to force indexes.. but it didn't help
Thank you
--
MySQL General Mailing List
For list archives: http://lists.
Thank you Mathias once again
> I suggest you to test after optimize table ... and analyze table ...
> if you stay with the problem and you can give me a set of data, i'll try to
> help
> more.
Initially while posting... i tried to reduce one table to avoid
complexity from the actual query. I'm
Selon Michael Stassen <[EMAIL PROTECTED]>:
> The PK is not used, nor should it be. Look at the EXPLAIN output.
Hi,
i hate the confusion people do between the primary key and the automatic index
on the PK.
Primary key is a generic concept for all databases. It assumes unicity and
managed data ins
[EMAIL PROTECTED] wrote:
Hi,
have you created an index on (id, testId) ?
i can't see the other indexes ? The only ones are the PK and testStudent, so the
PK is used.
The PK is not used, nor should it be. Look at the EXPLAIN output.
Let me rewrite the query with explicit joins, and reformat i
Sajith A wrote:
EXPLAIN SELECT qb_test_result.id resultId, qb_question.testId AS
testId, qb_test.title testName, qb_question.marks, qb_test.passrate,
qb_test_result.marks testMark, qb_test_result.percentage
testPercentage, qb_test_result.startTime, qb_test_result.endTime,
qb_test_result.status
Hi Sajith,
I tried to recreate you tables and do some tests, but i don't have significant
data. So i don't take your explain plan.
I suggest you to test after optimize table ... and analyze table ...
if you stay with the problem and you can give me a set of data, i'll try to help
more.
Mathias
S
Thank you Mathias for your time...
> have you created an index on (id, testId) ?
> i can't see the other indexes ? The only ones are the PK and testStudent, so
> the
> PK is used.
Yes i also tried that .. but it was not getting used.. it listed as
the possible_keys "PRIMARY" and "testStudent" but
Hi,
have you created an index on (id, testId) ?
i can't see the other indexes ? The only ones are the PK and testStudent, so the
PK is used.
Mathias
Selon Sajith A <[EMAIL PROTECTED]>:
> I was trying to analyze a query that was taking almost 4 seconds to
> execute. While trying to create additio
I was trying to analyze a query that was taking almost 4 seconds to
execute. While trying to create additional indexes - found that the
query is not using any index from table qb_test_result . The type
returned is ALL for qb_test_result .
I have given the tables and query below. It would have bee
11 matches
Mail list logo
