Sql dba unnara va evarina..

[Sarvapindi]

stored proc queries performance tuning seyyali..jara help needed

[duryaodhana]

I can give it a try 

[chapstick]

4 hours ago, Sarvapindi said:

stored proc queries performance tuning seyyali..jara help needed

Is this not developers work ?

[Sarvapindi]

17 minutes ago, chapstick said:

Is this not developers work ?

developer also

[ZoomNaidu]

15 minutes ago, Sarvapindi said:

developer also

High level lo post cheyi - can try.

[dasari4kntr]

cursors...ekkuva vunnaya..?

[Sarvapindi]

28 minutes ago, dasari4kntr said:

cursors...ekkuva vunnaya..?

No cursors...all temp tables..select into temp tables with lot of joins between tables. 
 

 

[Sarvapindi]

44 minutes ago, ZoomNaidu said:

High level lo post cheyi - can try.

Its basiclaly select into temp table from joining multiple tables..

select * into #temp1

from tableA 

join table b

join table c

join table d

where....

select * from table x  
into #temp2

from table y 

join #temp1

join temp 

etcc..so on..

final select statement is the result 

it has about  8 temp tables..

 

 

[dasari4kntr]

17 minutes ago, Sarvapindi said:

No cursors...all temp tables..select into temp tables with lot of joins between tables. 
 

 

CTE (WITH) try chesava...?  WITH recursion..?

[Sarvapindi]

5 minutes ago, dasari4kntr said:

CTE (WITH) try chesava...?  WITH recursion..?

Ya..first ade chesina..then went with temp tables

[ZoomNaidu]

29 minutes ago, Sarvapindi said:

Its basiclaly select into temp table from joining multiple tables..

select * into #temp1

from tableA 

join table b

join table c

join table d

where....

select * from table x  
into #temp2

from table y 

join #temp1

join temp 

etcc..so on..

final select statement is the result 

it has about  8 temp tables..

 

 

1. Temp table lo use only columns what u need - do not bring everything. 
2. select into #temp1 use cheyakunda, instead create a ddl for #temp1 and then use Insert into temp1 table. This will be little faster. 
3. make sure you use the correct filters in join conditions. 
Inka indexes, constraints kuda vuntaayi..

[dasari4kntr]

23 minutes ago, Sarvapindi said:

Ya..first ade chesina..then went with temp tables

sql server or oracle...?

select into badulu...try to create a temp table (local / global depends on your needs)...lantivi try cheyii..

break down your...massive single join to ..two to three..

may be that could help...

[Sarvapindi]

1 hour ago, dasari4kntr said:

sql server or oracle...?

select into badulu...try to create a temp table (local / global depends on your needs)...lantivi try cheyii..

break down your...massive single join to ..two to three..

may be that could help...

Sql server

[Sarvapindi]

2 hours ago, ZoomNaidu said:

1. Temp table lo use only columns what u need - do not bring everything. 
2. select into #temp1 use cheyakunda, instead create a ddl for #temp1 and then use Insert into temp1 table. This will be little faster. 
3. make sure you use the correct filters in join conditions. 
Inka indexes, constraints kuda vuntaayi..

will try thxz

[dasari4kntr]

7 hours ago, Sarvapindi said:

Sql server

then..

try the memory optimized tables...like below...

may be..you need to little research on that option....

 

CREATE TABLE dbo.ShoppingCart (   
    ShoppingCartId INT IDENTITY(1,1) PRIMARY KEY NONCLUSTERED,  
    UserId INT NOT NULL INDEX ix_UserId NONCLUSTERED
        HASH WITH (BUCKET_COUNT=1000000),
    CreatedDate DATETIME2 NOT NULL,   
    TotalPrice MONEY  
    ) WITH (MEMORY_OPTIMIZED=ON)   
GO