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/us/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 11:06:19

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?

Importantly, that investor viewpoint is not new. It cycles in when conditions are right (and vice versa). It also brings the ineffective warnings of an overpriced market with it.Looking toward a good 2022 stock market, there is no apparent reason to expect these issues to change.

Can I mute a Telegram group?

In recent times, Telegram has gained a lot of popularity because of the controversy over WhatsApp’s new privacy policy. In January 2021, Telegram was the most downloaded app worldwide and crossed 500 million monthly active users. And with so many active users on the app, people might get messages in bulk from a group or a channel that can be a little irritating. So to get rid of the same, you can mute groups, chats, and channels on Telegram just like WhatsApp. You can mute notifications for one hour, eight hours, or two days, or you can disable notifications forever.