I found "The world will come to an end, but music and love will endure" as the translation for your second tag line, but might I request a translation...

David Korb (3/23/2010)

---

Ed-997158 (3/23/2010)

---

David Korb (3/23/2010)

---

Tom Wilson (3/23/2010)

---

The basic idea for this topic is useful to brand-new database designeres - build a new table when there is a many-to-many relationship...

David Korb (3/23/2010)

---

Tom Wilson (3/23/2010)

---

The basic idea for this topic is useful to brand-new database designeres - build a new table when there is a many-to-many relationship between two other...

Thanks. I was just going to ask if "bridge table" didn't already have a different terminology

Ah, so you're blocking only for the time to change the status. Nice! Thanks!

Here is the definition of the table:

/****** Object: Table [dbo].[sysValidationList] Script Date: 1/26/2009 12:27:20 PM ******/

USE [DEV2-HRMS-036];

GO

SET ANSI_NULLS ON;

GO

SET QUOTED_IDENTIFIER ON;

GO

IF EXISTS (SELECT * FROM sys.objects WHERE object_id...

Thanks. The lightbulb is starting to go on.

Next question: The sysValidationList table (I did not design this), has a column, ValidationListID, of type int that is marked as...

From my brief reading on clustered index, they're useful for returning a range of values that have some meaningful sort order. Since this table uses a GUID for uniqueness,...

IX_sysValidationList is a unique, non-clustered index on the column, ValidationPartyID. Is this index not appropriate for these joins?

Also, when I try to use this query as the basis of...

Thanks Gail. I can't seem to figure out how to generate the xml in Toad, so I opened MS SQL Server Management Studio, ran the execution plan there, and...

It only takes about 2-3 seconds for the query, as opposed to about 60 seconds with all the joins to the lookup table.

When I tried that, it returned a second pane with a header, "Microsoft SQL Server XML Showplan", but there were no other contents. I was able to copy the...

Thanks for your help. I'm using Toad for SQL Server, so hopefully this is the format you're looking for.

Regards,

Ed

Thanks for the info. So even if 20 coded columns need to access the lookup table to decode to descriptions, a table scan will be performed 20 times? ...