Home Forums SQL Server 2008 T-SQL (SS2K8) findingdifference between full or partial index scan in graphical execution plan? RE: findingdifference between full or partial index scan in graphical execution plan?

  • GilaMonster (11/26/2012)

    ... you can tell partially from the number of rows outputted...

    Yes, in this case I can. But we have many, many, many tables and I don't know the number of records of any table by heart. So any time I want to know if it's a partial scan I have to determine the full number of rows first?

    The point is, many of our foreign keys reference to columns that are the clustered index so many joins result in clustered index lookups or scans. And that's where I want to know the difference. As the scan is done maybe multiple times I cannot even have a look at the logical reads as they are multiplied.