Learn new thing today 🙂

nice question..

+1 😛

Can you please provide us the table structure so that we can try to solve your problem?

Its good practice to provide detailed information so that everyone can understand problem that...

NIce basic question..

nice question and excellent explanation from you guys

really nice question.....

it exists on my same PC...

Can I create another instance with version 10.50.2500 on same PC ?

it takes about 13 min to execute 🙁

can we improve the %of table scan elements in Query execution plan?

thanks,

I will work on this 🙂

But all the columns on which you are suggesting to creating indexes, all are PK in their respective tables and as per my concern when we creating a PK it...

if i cerate index on the columns in list :

DimLocation(DimLocation)

DimInsurance(FinsCode, dimLocationId)

DimPatient(chartno, Fcategory, fPatient)

DimCategory(Fcategory)

lkpProvider(ProviderCode, ProviderCode)

DimProcedure(fProcedure)

TxPayPlan(Faccount, Finscode)

query will gets less time right?

No, I dont have have indexes..

please find the attached current execution plan..

these are the table structure that i am using:

CREATE TABLE [dbo].[DimInsurance](

[dimInsId] [int] IDENTITY(1,1) NOT NULL,

[EtlDate] [datetime] NOT NULL,

[dimLocationId] [int] NULL,

[dimInsuranceGroupId] [int] NULL,

[InsuranceGroupName] [nvarchar](30) NULL,

[Fcategory] [nvarchar](30) NULL,

[Fbillout] [tinyint] NULL,

[FinsCode] [nvarchar](10) NULL,

[Finsname]...

Good Question 🙂