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/ca/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 21:14:54

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 seemingly negative pandemic effects and resource/product shortages are encouraging and allowing organizations to innovate and change.The news of cash-rich organizations getting ready for the post-Covid growth economy is a sign of more than capital spending plans. Cash provides a cushion for risk-taking and a tool for growth.

How to Use Bitcoin?

n the U.S. people generally use Bitcoin as an alternative investment, helping diversify a portfolio apart from stocks and bonds. You can also use Bitcoin to make purchases, but the number of vendors that accept the cryptocurrency is still limited. Big companies that accept Bitcoin include Overstock, AT&T and Twitch. You may also find that some small local retailers or certain websites take Bitcoin, but you’ll have to do some digging. That said, PayPal has announced that it will enable cryptocurrency as a funding source for purchases this year, financing purchases by automatically converting crypto holdings to fiat currency for users. “They have 346 million users and they’re connected to 26 million merchants,” says Spencer Montgomery, founder of Uinta Crypto Consulting. “It’s huge.”