name
FROM customer1
WHERE EXTRACT(ISODOW FROM birthday) IN (1,5)
AND name ILIKE 'b%'
UNION ALL
SELECT
name
FROM employee
WHERE EXTRACT(ISODOW FROM birthday) IN (1,5)
AND name ILIKE 'b%'
Вопрос по этому запросу с целью сделать быстрее
what do you think about following part in where?
name between "b" and "b" and name between "B" and "B"
Are there some advantages? Are there some disadvantages? Could you do some execution time estimates? Could you compare it with your solution?
кто "он"?
он хочет, чтобы ты посмотрел на explain
Никита, а какие строки могут быть на входе у ILIKE?
Обсуждают сегодня