TG: oracle_dbd/920

Forwarded from Pavel V

Таблица sales_data — 50 млн записей.
Колонки:
a) region — 10 уникальных значений; b) product_category — 12 типов; c) sales_channel — 3 канала продаж; d) amount — сумма покупки Какая стратегия индексирования даст наилучшую производительность?

Anonymous Quiz

Один составной B-tree индекс (region, product_category, sales_channel)

Bitmap-индексы на каждую из трех колонок

Bitmap только на sales_channel

Индексы не нужны — всё читаем full scan’ом

226 answered

www.tg-me.com/ye/Oracle Developer‍/com.oracle_dbd/920

1.3K viewsMay 26 at 11:30

tg-me.com/oracle_dbd/920

Create: 2025-05-26
Last Update: 2025-07-05 23:07:08

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/920

Oracle Developer‍ Telegram | DID YOU KNOW?

The Singapore stock market has alternated between positive and negative finishes through the last five trading days since the end of the two-day winning streak in which it had added more than a dozen points or 0.4 percent. The Straits Times Index now sits just above the 3,060-point plateau and it's likely to see a narrow trading range on Monday.

Unlimited members in Telegram group now

Telegram has made it easier for its users to communicate, as it has introduced a feature that allows more than 200,000 users in a group chat. However, if the users in a group chat move past 200,000, it changes into "Broadcast Group", but the feature comes with a restriction. Groups with close to 200k members can be converted to a Broadcast Group that allows unlimited members. Only admins can post in Broadcast Groups, but everyone can read along and participate in group Voice Chats," Telegram added.