Milliseid andmetüüpe on parem vältida andmebaasis indekseerimisel?

Database indexing is better avoided on the following data types:

• Long text fields (e.g., TEXT, BLOB), as indexes on them occupy a lot of space and operate slowly.
• Floating point types (float, double), because their storage and comparison characteristics can cause indexes to function incorrectly or inefficiently.
• Types with high variability or low selectivity, such as boolean fields or fields with very few unique values, as indexes on these are less effective.

It is better to use fixed-length types with high selectivity, such as integer types (INT, BIGINT) or short strings (VARCHAR with limited length).