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/it/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-04 10:37:04

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?

NEWS: Telegram supports Facetime video calls NOW!

Secure video calling is in high demand. As an alternative to Zoom, many people are using end-to-end encrypted apps such as WhatsApp, FaceTime or Signal to speak to friends and family face-to-face since coronavirus lockdowns started to take place across the world. There’s another option—secure communications app Telegram just added video calling to its feature set, available on both iOS and Android. The new feature is also super secure—like Signal and WhatsApp and unlike Zoom (yet), video calls will be end-to-end encrypted.