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/us/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-01 19:45:58

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?

Telegram is riding high, adding tens of million of users this year. Now the bill is coming due.Telegram is one of the few significant social-media challengers to Facebook Inc., FB -1.90% on a trajectory toward one billion users active each month by the end of 2022, up from roughly 550 million today.

The messaging service and social-media platform owes creditors roughly $700 million by the end of April, according to people briefed on the company’s plans and loan documents viewed by The Wall Street Journal. At the same time, Telegram Group Inc. must cover rising equipment and bandwidth expenses because of its rapid growth, despite going years without attempting to generate revenue.