select *, cast(reads as real)/ cast(isnull(nullif(writes,0),1) as real) ratio
from   (
         SELECT OBJECT_NAME(s.[object_id]) AS [ObjectName],
                i.name AS [IndexName] , i.index_id , 
                user_seeks + user_scans + user_lookups AS [Reads] , 
                user_updates AS [Writes] , 
                i.type_desc AS [IndexType] , 
                i.fill_factor AS [FillFactor]
         FROM   sys.dm_db_index_usage_stats AS s 
         JOIN   sys.indexes AS i ON s.[object_id] = i.[object_id]
         WHERE  OBJECTPROPERTY(s.[object_id], 'IsUserTable') = 1 
           AND  i.index_id = s.index_id 
           AND  s.database_id = DB_ID()
           AND  OBJECT_NAME(s.[object_id]) = 'MyTableName'
       ) v
ORDER BY ratio;

declare @database sysname = N'MyDB', 
        @schema   sysname = N'MySchema', 
        @table    sysname = N'MyTableName', 
        @index    sysname = N'MyIndexName';
-- 
with xmlnamespaces(default 'http://schemas.microsoft.com/sqlserver/2004/07/showplan')
select qp.x, i.LogicalOp, object_schema_name(qt.objectid, qt.dbid), object_name(qt.objectid, qt.dbid), st.statement_text
from   sys.dm_exec_query_stats qs cross apply
       sys.dm_exec_text_query_plan(qs.plan_handle, qs.statement_start_offset, qs.statement_end_offset) tqp 
cross  apply sys.dm_exec_sql_text(qs.sql_handle) qt 
cross  apply (select quotename(@database), quotename(@schema), quotename(@table), quotename(@index)) o([database], [schema], [table], [index]) 
cross  apply (select substring(qt.text, 
                               (qs.statement_start_offset / 2) + 1, 
                               ((case qs.statement_end_offset when -1 then datalength(qt.text) else qs.statement_end_offset end - qs.statement_start_offset) / 2) + 1)) st(statement_text) 
cross  apply (select cast(case when st.statement_text is not null then tqp.query_plan end as xml) where charindex(o.[index], tqp.query_plan) > 0) qp(x) 
cross  apply (
               select t.n.value('../../@LogicalOp', 'nvarchar(100)')
               from   qp.x.nodes('//RelOp/IndexScan/Object[@Database = sql:column("o.database") and @Schema = sql:column("o.schema") and @Table = sql:column("o.table") and @Index = sql:column("o.index")]') t(n)
               where  qp.x is not null
             ) i(LogicalOp);