Please ignore this topic.

I am a newbie and I created a topic when I was trying to post a reply to a topic.

Include usage of indexes on views?

Something like:

Change: INNER JOIN sys.tables st ON st.[object_id] = si.[object_id]

To: INNER JOIN sys.objects st ON st.[object_id] = si.[object_id] AND st.type IN ('U','V')

Your script will be...

With XML you can return many recordsets (say a complex hierarchy) in a single xml document, a single database hit.