Other question is, what DB is this for?
Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com
YVES SUCAET wrote:
> How could I rewrite the following query so it runs faster:
>
> select distinct location from blockunit where blockid in (
> select bu.blockid from b
If you can answer the other questions that would help as well
you can try rewriting using "exist" instead of "in"
But without the basic information like number of records expected and
explain plan it is very hard to come up with a better solution.
Brgds
Jack
2008/9/26 Chris <[EMAIL PROTECTED
Jack van Zanen wrote:
Hi
If I am not mistaken,
the second part of the union contains all rows that are in the first part of
the union. just remove the first part.
Kind of.
The first part is a join, the second isn't.
I was going to suggest rewriting the subquery into a single:
where
ip.block
Hi
If I am not mistaken,
the second part of the union contains all rows that are in the first part of
the union. just remove the first part.
Also
What is the table sizes of the tables?
How many records are expected to come back from the union sub query?
How many records are expected to come
Micah Gersten wrote:
What indices do you have?
Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com
YVES SUCAET wrote:
How could I rewrite the following query so it runs faster:
select distinct location from blockunit where blockid in (
select bu.blockid fro
What indices do you have?
Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com
YVES SUCAET wrote:
> How could I rewrite the following query so it runs faster:
>
> select distinct location from blockunit where blockid in (
> select bu.blockid from blockunit bu in
How could I rewrite the following query so it runs faster:
select distinct location from blockunit where blockid in (
select bu.blockid from blockunit bu inner join interactionparts ip on
(bu.blockid = ip.part)
where ip.blockid in
(110936,110937,111641,111642,113140,113141,114925,114926,12
Hi
> Could any 1 please help on how to insert using phpMyAdmin??
I haven't used phpMyAdmin in years, but here's how I'd do it in SQL with
my favourite tool (SQLyog)
LOAD DATA LOCAL INFILE 'C:\file_name.txt'
INTO TABLE tbl_name
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'
IGNORE 1 L
