Choose indexes(1)

• Index file type:

• B-tree 最常見
• some DBMS can select index file type
• some DBMS support full-text search index
• Bitmap Index:suitable for domain with few possible value
• Join Indexes