Sure! Below is an SEO-friendly HTML answer for the interview question "What is the difference between a clustered and non-clustered index in DB2?":

```html

Difference Between Clustered and Non-Clustered Index in DB2

In DB2, a clustered index is a type of index where the physical order of the data in the table matches the order of the index. This means that the rows are stored sequentially on disk based on the indexed column. On the other hand, a non-clustered index does not store the data rows in the same order as the index, but instead maintains a separate structure with pointers to the actual rows.

The main difference between a clustered and non-clustered index in DB2 is the way data is physically organized on disk. A clustered index can improve performance for range queries and data retrieval operations that benefit from sequential access, while a non-clustered index is more versatile for optimizing various types of queries.

It's important to consider the specific use case and performance requirements when deciding between a clustered and non-clustered index in DB2, as each type has its own advantages and limitations.

For more in-depth information on clustered and non-clustered indexes in DB2, consult the official IBM DB2 documentation or seek guidance from database experts.

```

Focus keyword: clustered and non-clustered index in DB2

This HTML answer provides a clear explanation of the difference between clustered and non-clustered indexes in DB2 while ensuring it is SEO-friendly by including relevant keywords and descriptive content.