TG: oracle_dbd/922

Forwarded from Pavel V

Таблица customer_surveys содержит 2 млн строк.
Колонки:
a) age_group (группы по возрасту: 10-19, 20-29, ..., 60+); b) income_level (5 категорий); c) country_code (около 200 стран), survey_text (CLOB). Данные не обновляются. Какой индекс будет эффективен?

Anonymous Quiz

B-tree по income_level и country_code

Bitmap по income_level, country_code и age_group

Bitmap только по survey_text

Индекс не нужен, хватит full scan

187 answered

www.tg-me.com/sa/Oracle Developer‍/com.oracle_dbd/922

1.2K viewsMay 26 at 11:30

tg-me.com/oracle_dbd/922

Create: 2025-05-26
Last Update: 2025-07-02 12:23:29

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

Oracle Developer‍ Telegram | DID YOU KNOW?

The S&P 500 slumped 1.8% on Monday and Tuesday, thanks to China Evergrande, the Chinese property company that looks like it is ready to default on its more-than $300 billion in debt. Cries of the next Lehman Brothers—or maybe the next Silverado?—echoed through the canyons of Wall Street as investors prepared for the worst.

The STAR Market, as is implied by the name, is heavily geared toward smaller innovative tech companies, in particular those engaged in strategically important fields, such as biopharmaceuticals, 5G technology, semiconductors, and new energy. The STAR Market currently has 340 listed securities. The STAR Market is seen as important for China’s high-tech and emerging industries, providing a space for smaller companies to raise capital in China. This is especially significant for technology companies that may be viewed with suspicion on overseas stock exchanges.