Indexes can enforce uniqueness via unique constraints, ensuring no duplicate values. Tables are unordered sets (ordered only via ORDER BY), indexes can be ascending or descending, and views are virtual tables storing no data themselves (queries run on demand).