rk?
Arnaud
- Original Message -
From: "Ed McNierney" <[EMAIL PROTECTED]>
To: "Arnaud" <[EMAIL PROTECTED]>; "mysql List"
<[EMAIL PROTECTED]>
Sent: jeudi 20 novembre 2003 18:20
Subject: RE: Cannot find an index that will be used for SELECT
Arnau
om: Ed McNierney
To: [EMAIL PROTECTED]
Sent: Thursday, November 20, 2003 11:22 AM
Subject: Cannot find an index that will be used for SELECT
I'm completely stumped trying to create any index MySQL will use at all
for my SELECT.
I've got a table with four columns describ
erney; mysql List
Subject: Re: Cannot find an index that will be used for SELECT
Hi Ed,
May you could join the table to itself, using a join criteria of index and
position :
SELECT * FROM ROWS AS R1 LEFT JOIN ROWS AS R1 ON (R1.index=R2.index AND
R2.X<=Right) LEFT JOIN ROWS AS R3 ON (R1.index=
Hi Ed,
May you could join the table to itself, using a join criteria of index and
position :
SELECT * FROM ROWS AS R1 LEFT JOIN ROWS AS R1 ON (R1.index=R2.index AND
R2.X<=Right) LEFT JOIN ROWS AS R3 ON (R1.index=R3.index AND R3.X>=Left) LEFT
JOIN etc etc...
Does that help?
Arnaud
--
MySQL Ge
I'm completely stumped trying to create any index MySQL will use at all
for my SELECT.
I've got a table with four columns describing the upper-right and
lower-left coordinates of a rectangle - RIGHT, LEFT (max X, min X), TOP,
BOTTOM (max Y, min Y). I have an X, Y coordinate and I want to select
