<div>
How many rows return from each table?<br />
<br />
SELECT COUNT(*) FROM [server].base.sys.schemas WHERE name = 'TESTS'<br />
SELECT COUNT(*) FROM ods.schema.table WHERE [ZDOS_0] = 'TEST'<br />
<br />
Since I'm wonder why it will take some significant process time.
</div>


How many rows return from each table?

SELECT COUNT(*) FROM [server].base.sys.schemas WHERE name = 'TESTS'
SELECT COUNT(*) FROM ods.schema.table WHERE [ZDOS_0] = 'TEST'

Since I'm wonder why it will take some significant process time.

<div>
7332245rows and 2345673rows<br />
Thanks<br />
Regards<br />
bibi
</div>


7332245rows and 2345673rows
Thanks
Regards
bibi

<div>
Not sure if this will help<br />
<br />

<pre><code id="code-20-35153397-1">DECLARE @name sysname -- change datatype if need to
SELECT @name = name FROM [server].base.sys.schemas WHERE name = 'TESTS'

SELECT *, @name as [ZDOS_0]
INTO #stmt_repl
FROM [server].base.schema.table

UPDATE #stmt_repl
SET x = NULL
FROM ods.schema.table OST
WHERE #stmt_repl.rowid = OST.ZROWID_0 -- if field name is not rowid, change it to the correct one
AND OST.ro = 'TEST'</code></pre>
</div>


Not sure if this will help



DECLARE @name sysname -- change datatype if need to
SELECT @name = name FROM [server].base.sys.schemas WHERE name = 'TESTS'

SELECT *, @name as [ZDOS_0]
INTO #stmt_repl
FROM [server].base.schema.table

UPDATE #stmt_repl
SET x = NULL
FROM ods.schema.table OST
WHERE #stmt_repl.rowid = OST.ZROWID_0 -- if field name is not rowid, change it to the correct one
AND OST.ro = 'TEST'

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
How can I optimize this statement which takes time :<br />
<br />
select * &nbsp; ,<br />
(<br />
select name <br />
from [server].base.sys.schemas<br />
where name = 'TESTS' and rowid not in (select ZROWID_0 from &nbsp;ods.schema.table where [ZDOS_0] = 'TEST')<br />
<br />
) as [ZDOS_0] into #stmt_repl<br />
from [server].base.schema.table<wbr /><br />
<br />
Thanks<br />
<br />
bibi
</div>
</div>


Hello,

How can I optimize this statement which takes time :

select *   ,
(
select name 
from [server].base.sys.schemas
where name = 'TESTS' and rowid not in (select ZROWID_0 from  ods.schema.table where [ZDOS_0] = 'TEST')

) as [ZDOS_0] into #stmt_repl
from [server].base.schema.table

Thanks

bibi

optimize sql statement

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.