This script will lists statistics for existing indexes.

<cffunction name="getIndexStats" output="No" returntype="any" description="lists statistics for existing Indexes, ordered by user_updates.">
   <cfargument name="DBName" default="master" type="any">
   <cfargument name="DBObjName" default="" type="any">
   <cfargument name="indexName" default="" type="any">
   <cfset var getIndexStats = "">
   <cfquery name="getIndexStats" datasource="yourdsn" username="youruserName" password="yourpasswd">
      use #DBName#
      Select   s.*, db_name(s.database_id) as dbName, object_name(s.object_id) as objName, as index_name
      From sys.dm_db_index_usage_stats s, sys.indexes i, sys.objects o
      Where i.index_id = s.index_id
         and o.type = 'U'
         and o.object_id = i.object_id
      <cfif Len(Trim(DBObjName))>
         and s.object_id = object_id('#DBObjName#')
      <cfif Len(Trim(indexName))>
         and = '#indexName#'
      Order by user_updates desc
   <cfreturn getIndexStats>