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/in/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-02 14:59:40

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?

Traders also expressed uncertainty about the situation with China Evergrande, as the indebted property company has not provided clarification about a key interest payment.In economic news, the Commerce Department reported an unexpected increase in U.S. new home sales in August.Crude oil prices climbed Friday and front-month WTI oil futures contracts saw gains for a fifth straight week amid tighter supplies. West Texas Intermediate Crude oil futures for November rose $0.68 or 0.9 percent at 73.98 a barrel. WTI Crude futures gained 2.8 percent for the week.

A project of our size needs at least a few hundred million dollars per year to keep going,” Mr. Durov wrote in his public channel on Telegram late last year. “While doing that, we will remain independent and stay true to our values, redefining how a tech company should operate.