Explain the concept of indexing in SQL Server. How do clustered and non-clustered indexes affect read and write performance?
