Indexes should NOT be used on ( ).
A: small tables
B: tables that have frequent, large batch updates or insert operations
C: columns that are frequently manipulated
D: highly-selective filter columns
A: small tables
B: tables that have frequent, large batch updates or insert operations
C: columns that are frequently manipulated
D: highly-selective filter columns
举一反三
- 下列MySQL命令正确的是( ) A: show databases; B: show tables; C: show columns; D: show columns from customers;
- 下列正确的命令是( ) A: show tables; B: show columns; C: show columns from 表名; D: show databases;
- Bitmap indexes are best suited for columns with;() A: High selectivity B: Low selectivity C: High inserts D: high updates
- 下列正确的命令是( ) A: show tables; B: show columns; C: create database test; D: show databases;
- To make effective tables, you should _________. A: arrange data of the shorter string into columns B: use complete sentences as the table titles C: use only three horizontal rules for the table D: line up numbers on the left