When you execute sp_help and sp_helpindex in a database, and give a table’s name, you see information about which segment(s) stores the table or its indexes.
For example:
sp_helpindex authors
index_name index_description index_keys ------------ ----------------------------------- ---------- au_index nonclustered located on seg_mydisk2 au_id
