tony28 (10/16/2013)

---

I founded that if I start the select twice, the second select is almost always the good time, but sometimes is same or worst,

It is possible that can be...

Sean Lange (10/16/2013)

---

What you have there is called a multi statement table valued function (MTVF). The performance of these can be a killer. Check out this post from Wayne Sheffield...

I founded that if I start the select twice, the second select is almost always the good time, but sometimes is same or worst,

It is possible that can be problem...

or now I tried left join with MASTER table

Table 'Worktable'. Scan count 0, logical reads 0, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads...

Hi,

I think that you have logical 2instance, but physical 4 - because there are mirrored and in cluster, so you can use just one side - but this is according...

tony28 (5/21/2013)

I read that

- number of temp db files like CPU - 16 ? true or false ?

Rule of thumb before we starting getting rediculous amounts of cores. At that...

hello guys,

I never talk with someone about this, so now I know, thx for response...

Can be problem with some convert? char-varchar? or somethink? or that the primary key in table is string ?

I dont know, why the query selected all tables with union...

here is simple select, I found in little difficult, but here you can see also

subtree cost

IX 0,0032838 -...

hi, thx for reply

I didnt write all about it ..heh

these columns are in PK

when I executed query, in tab of execution plan was the label - MISSING INDEX and...

😎

yes, for example we have 10 table --- TB_MASTER_CPM01 - 10 and inside each of tables is column LINE_CODE with end of name this table, I dont know why korean...

I would like use for best one of first three queries

but

first is not good, because there is still recreate ex.plan

second is slowly, because without OPTION(RECOMPILE) the select selected...

opc.three (4/27/2013)

---

It has to do with how a plan...

I used OPTION(RECOMPILE) and it is ok, but without is wrong,,,---- and in milisecond is little worst, but better than before. ,