I have a large SQL statement with several joins and there is a bookmark lookup I'm trying to eliminate.
When I use Showplan, in the output column lists a number of columns. In another article it mentioned in an example that the columns mentioned in the Output column when running Showplan should be the ones needed to create a covering index. Is this correct? And