0
Is there any way to optimize query sql, where it is necessary to truncate two dates of a column?
Select *
from work_table a
where trunc(a.datetime) = trunc(a.datetime);
0No answers
Browser other questions tagged sql oracle
You are not signed in. Login or sign up in order to post.
I did not understand your question. The WHERE clause above will not always be true?
– anonimo
It doesn’t make sense this query, can explain your problem better?
– Tmilitino
It would be a performance problem in the case , when using truncate two dates in the Where condition, in the case the above example is just a personification of the situation. -- > WHERE TRUNC(DATATIME) = TRUNC(DATATIME)
– GaberRB
Analyze the execution plan and whether using a Function based index helps improve performance.
– anonimo