TG: oracle_dbd/924

Forwarded from Pavel V

Таблица web_events — 100 млн строк.
Колонки:
a) device_type — 'Mobile', 'Tablet', 'Desktop'; b) browser — 8 типов; c) country_code — 50 значений; d) event_time — временная метка; e) event_type — 'CLICK', 'VIEW', 'PURCHASE' Что будет наиболее эффективно?

Anonymous Quiz

Один составной B-tree (device_type, browser, country_code, event_type)

Bitmap по device_type, browser, country_code, event_type

Только индекс по event_time

Не индексировать — таблица и так летает

190 answered

www.tg-me.com/hk/Oracle Developer‍/com.oracle_dbd/924

1.1K viewsMay 26 at 11:30

tg-me.com/oracle_dbd/924

Create: 2025-05-26
Last Update: 2025-07-04 08:10:52

BY Oracle Developer👨🏻‍💻

Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/oracle_dbd/924

Oracle Developer‍ Telegram | DID YOU KNOW?

Tata Power whose core business is to generate, transmit and distribute electricity has made no money to investors in the last one decade. That is a big blunder considering it is one of the largest power generation companies in the country. One of the reasons is the company's huge debt levels which stood at ₹43,559 crore at the end of March 2021 compared to the company’s market capitalisation of ₹44,447 crore.

Why Telegram?

Telegram has no known backdoors and, even though it is come in for criticism for using proprietary encryption methods instead of open-source ones, those have yet to be compromised. While no messaging app can guarantee a 100% impermeable defense against determined attackers, Telegram is vulnerabilities are few and either theoretical or based on spoof files fooling users into actively enabling an attack.