sql server - Why is selecting date slow -


this question has answer here:

i have table 1.5 million rows date_run indexed non cluster. query #1 takes 0 second finish , query #2 takes 3 seconds. can please explain why query #2 runs slower. included execution plans both. sql server version 2014.

query #1

select  avg14gain stocktrack  date_run >=  '2013-3-21' , date_run <  '2013-3-22'

valid xhtml http://biginkz.com/pics/datehardcoded.jpg.

query #2

declare @today date declare @yesterday date set @today='2013-3-22' set @yesterday='2013-3-21' select avg14gain stocktrack  date_run  >=   @yesterday , b.date_run <@today

valid xhtml http://biginkz.com/pics/dataasigned.jpg.

i not sure why query not picking index, can use index hint.

try this:

declare @today date declare @yesterday date set @today='2013-3-22' set @yesterday='2013-3-21' select avg14gain stocktrack  date_run  >=   @yesterday , b.date_run <@today (index([stocktrack].[ix_drun]))

also can try suggested in post: tsql not using indexes. see @justin dearing's answer (rebuild index / update statistics).


Comments

Post a Comment

Popular posts from this blog

IF statement in MySQL trigger -

this query code in mysql trigger. if 1=2 select 'yes'; else select 'no'; end if; but has following error: if '1'='2' select 'yes' error code: 1064. have error in sql syntax; check manual corresponds mysql server version right syntax use near 'if '1'='2' select 'yes'' @ line 1 0.000 sec what solution?
Read more

c++ - What does MSC in "// appease MSC" comments mean? -

i run across // appease msc in c++ comments, e.g. here : const int& array::operator[](int offset) const { int mysize = getitssize(); if (offset >= 0 && offset < getitssize()) return ptype[offset]; throw xboundary(); return ptype[offset]; // appease msc! } what msc stand ? the author means microsoft's compiler, more formally known msvc.
Read more

android - MPAndroidChart - How to add Annotations or images to the chart -

i working latest mpandroidchart library , looking way add annotations or images clickable. example: once data reaches value event occurs want able display user - there multiple events can occur annotations (not sure if right word) or image added @ point in chart. any pointers welcome. check documentation of yaxis . focus on setspacetop(...) , setaxismaxvalue(...) methods. for background: bar-shadow , disable calling: barchart.setdrawbarshadow(false) or change color: bardataset.setbarshadowcolor(int color)
Read more