sql helf ravali ravali

[nenu_devudni]

In my query i am checking if my date field is equal to sysdate .. and using trunc on both ends .. and my date field has a index on it .. and by using trunc .. aa index dobutundi .. and its taking lot of time to execute .. how do i keep my index from not blowing using trunc ... seppandi vay 

[nenu_devudni]

@loveindia thatha ravali .. nanu ee gothi lo nundi bayatiki teyali 

[nenu_devudni]

[nenu_devudni]

[150bryant]

indexed-date field ni inko additional column/field ga pull/populate cheyi... aa field ki edoka alias peru ivu.. 

do operations on that alias field

in short: you are creating a substitution field..without messing wit indexing

[SwamyRaRa]

Disable index and truncate table 

then insert after insert create index 

[nenu_devudni]

1 minute ago, SwamyRaRa said:

Disable index and truncate table 

then insert after insert create index 

adi production table thatha ..ala cheste bagodu emo kada 

[nenu_devudni]

16 minutes ago, 150bryant said:

indexed-date field ni inko additional column/field ga pull/populate cheyi... aa field ki edoka alias peru ivu.. 

do operations on that alias field

in short: you are creating a substitution field..without messing wit indexing

koncham confeesing ga undi vuncle ...   

[nenu_devudni]

23 minutes ago, 150bryant said:

indexed-date field ni inko additional column/field ga pull/populate cheyi... aa field ki edoka alias peru ivu.. 

do operations on that alias field

in short: you are creating a substitution field..without messing wit indexing

select trunc(my_date_field) as req_date,
(select count(*) from tablename
where blah_blah = 'O'
and bluh_bluh= 'RMTE'
and bleh_bleh = 'C11'
and req_date = trunc(sysdate) 
 ) from tablename b
 

did u mean something like this ?

[Butterthief]

ok

[SwamyRaRa]

1 hour ago, nenu_devudni said:

adi production table thatha ..ala cheste bagodu emo kada 

Oh prod.. Ok 

[nenu_devudni]

 sepanndi me mokal mands uuu .. 

[Tesla]

 

select * from tab1 where load_dt > trunc(sysdate)

 

or

 

select * from tab1 where load_dt between trunc(sysdate) and trun(sysdate)+1

[nenu_devudni]

8 minutes ago, Tesla said:

 

select * from tab1 where load_dt > trunc(sysdate)

 

or

 

select * from tab1 where load_dt between trunc(sysdate) and trun(sysdate)+1

tanks tesla vuncle .. this worked