• I too never create stats stuff manually.

    The other 'tool' to use for creating indexes is just to put the query into the explain tool, see what indexes it does or does not use and manually try different indexes to see if it changes the access plan... in a nonprod environment of course.