clustered and nonclustered index : the difference

[bluenectar]

dear all,
sorry if I asked some basic question (again), I want to know what's makes difference between clustered and nonclustered index ? Seeing that in performance view, what will happen if we put clustered and nonclustered index together in the same table? is there any rule when we create it ?

thanks in advance,

[rmiao]

In MS sql, clustered index's leaf pages are data pages and table will be physical ordered by clustered index. You can have one clustered index and 249 non-clustered indexes on each table, books online has details.

[bluenectar]

books online has details that very hard to be understand by me the answers of my questions will not found at books online..I need your guide about this, thx rmiao

[rmiao]

There is no simple guide works everywhere. Kalen Delaney has lot of articles on this issue, search them in www.sqlmag.com.

[bluenectar]

thanks rmiao