Is this a start?

SELECT		Object_Name(syob.id)

FROM		master.dbo.syslocks sylo WITH (NOLOCK)

		JOIN

		<DBName>.dbo.sysobjects syob WITH (NOLOCK)

		ON sylo.id = syob.id

WHERE		syob.type = 'U'

		AND sylo.dbid = (DB_ID('<DBName>'))

SJTerrill

Thanks for the input, Ian. Your take on this is appreciated. So, since the records in sysindexes don't equate to indexes... but in fact to statistics; there's really no harm...

yogiberr, I just scripted out this structure (SQL2K). Only three tables and barebones columns, but I hope it helps. Just create an empty database and run this.

The structure explicitly requires...

If I understand you correctly, try this:

SELECT        Products.*

FROM          Products

 ...

yogiberr, You have indeed followed correctly. You may want to use table & column names more familiar to users of an order management system: Part or Product for Part, Kit...

Having a background in market research (from the DBA side! Not the marketroids! I swear!), I'd also be interested in these metrics.

Cool Suggestion,

SJTerrill

P.S. Or is this just a step-up upgrade...

yogiberr, no fear! You've not been interpreted as lazy! Following are some brief responses. If this remains clear as mud, I'll try and dig up a real-world example from my...

yogiberr, This is not unlike a Part's relationship to its Bill of Materials. Each Part can be made up of many other Parts. In theory, you'll only need a tblPart,...

Thanks for the response!

When performance is lower (it's never really slow), it's on reads. That answers my primary question on indexing.

The database is stored on a single file on a...

Thanks, cneuhold. I've got some more questions regarding these objects... I'll start another thread.

SJTerrill

Zarathustra, I think I see your point. I checked the link and it discusses GROUP BY, not the GROUPING keyword. Perhaps GROUPING is useful in situations where you want to...

Ah... Thanks!

Just took a look at another database we've got here... It's got over 600 of those objects. Not a one-off!

Off to the races.

Thanks Again,

SJTerrill

So, if I consistently see these... consider an index on the columns effected?

Oh gurus,

I'd also love to know what's up with these, apparently, dynamically created indexes. We've got several floating around in our production databases. Is there a methodology, or even need,...

pliant, Methinks the boolean the better of your two choices. However, if this is an inventory management application, there might be a better way. Not to 'soapbox', but:

Most inventory management...