i have table below:
create table metaltemprature( idmetaltemprature int rawtime bigint not null, metal nchar(7) not null, color nchar(5) not null, temp float not null)
and blow index:
primary key clustered ( idmetaltemprature asc )with (pad_index = off, statistics_norecompute = off, ignore_dup_key = off, allow_row_locks = on, allow_page_locks = on) on primary ) on primary create nonclustered index nonclusteredindex1112 on metaltemprature ( rawtime desc )with (pad_index = off, statistics_norecompute = off, sort_in_tempdb = off, drop_existing = off, online = off, allow_row_locks = on, allow_page_locks = on) on primary
when run query take 0 sec that:
select count(*) metaltemprature rawtime < 4449449575 , rawtime > (4449449575 -10000000) , metal = 'iron';
but when put query under other select below
select select count(*) metaltemprature rawtime < other.rawtime , rawtime > (other.rawtime -10000000) , metal = 'iron'; other_table_only_one_row other;
this take 60 sec (when other.rawtime 4449449575 , result of both queries same)why?
select * other_table_only_one_row other, (select count(*) metaltemprature rawtime < other.rawtime , rawtime > (other.rawtime -10000000) , metal = 'iron') cnt
place from
section execute once
Comments
Post a Comment