|
Перехват и изменение запроса SELECT
#39884013
Ссылка:
Ссылка на сообщение:
Ссылка с названием темы:
Ссылка на профиль пользователя:
|
|
|
|
_WeSTMan_Maxim Bogukпропущено...
это если условий на join нет.... в вашем случае запросы будут 100% одинаковы и по плану и по результатам...
писать можно и так и эдак как кому нравится
Условие на JOIN есть. Посмотрите, пожалуйста, выше в пример INNER JOIN
"а ты упорный, парамоша (сс)"
приведите планы для следующих запросов :
"CROSS запрос"
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
EXPLAIN ANALYZE SELECT /*DISTINCT*/ t0.ID AS a1, t0.assignee AS a2, t0.COMMENT AS a3, t0.DATECREATED AS a4, t0.DATEFINISHED AS a5, t0.DECLARANT AS a6, t0.default_max_interval AS a7, t0.default_rest_interval AS a8, t0.internal_request_id AS a9, t0.last_editor AS a10, t0.last_task_groups AS a11, t0.max_date AS a12, t0.PROCESSINSTANCEID AS a13, t0.rest_date AS a14, t0.STATUS AS a15, t0.TAG AS a16, t0.type AS a17, t0.VERSION AS a18, t0.worked_days AS a19, t0.EMPLOYEE_LOGIN AS a20, t0.gid AS a21, t0.PROCEDURE_ID AS a22, t0.PROCEDUREPROCESSDEFINITION_PROCESSDEFINITIONID AS a23
FROM BID t0, bidworkers t1
WHERE (
(
(1 = 1)
AND (
(
(
(
(
(t0.type = 4) OR (t0.STATUS = 14)
)
OR (
(t0.type = 1) AND (t0.STATUS = 8)
)
)
OR (
(t0.type = 0) AND (t0.STATUS IN (6,7,13,8))
)
)
OR (
(t0.type = 3) AND (t0.STATUS IN (6,7,8))
)
)
OR (
(t0.type = 2) AND (t0.STATUS IN (6,9,8))
)
)
)
AND (t0.ID = t1.bid_id)) ORDER BY t0.DATEFINISHED ASC LIMIT 15 OFFSET 0;
INNER запрос
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
EXPLAIN ANALYZE SELECT DISTINCT t0.ID AS a1, t0.assignee AS a2, t0.COMMENT AS a3, t0.DATECREATED AS a4, t0.DATEFINISHED AS a5, t0.DECLARANT AS a6, t0.default_max_interval AS a7, t0.default_rest_interval AS a8, t0.internal_request_id AS a9, t0.last_editor AS a10, t0.last_task_groups AS a11, t0.max_date AS a12, t0.PROCESSINSTANCEID AS a13, t0.rest_date AS a14, t0.STATUS AS a15, t0.TAG AS a16, t0.type AS a17, t0.VERSION AS a18, t0.worked_days AS a19, t0.EMPLOYEE_LOGIN AS a20, t0.gid AS a21, t0.PROCEDURE_ID AS a22, t0.PROCEDUREPROCESSDEFINITION_PROCESSDEFINITIONID AS a23
FROM BID t0 INNER JOIN bidworkers ON t0.ID = bidworkers.bid_id
WHERE (
(
(1 = 1)
AND (
(
(
(
(
(t0.type = 4) OR (t0.STATUS = 14)
)
OR (
(t0.type = 1) AND (t0.STATUS = 8)
)
)
OR (
(t0.type = 0) AND (t0.STATUS IN (6,7,13,8))
)
)
OR (
(t0.type = 3) AND (t0.STATUS IN (6,7,8))
)
)
OR (
(t0.type = 2) AND (t0.STATUS IN (6,9,8))
)
)
)
)
ORDER BY t0.DATEFINISHED ASC LIMIT 15 OFFSET 0
после чего перечитайте топек |
|
|
