Hi,
I have a composite index which consist of character field, DateTime field, character field.
When I try to select record by using CharField + CAST(DateTimeField AS CHAR(8)) + CharField2 expression, it doesn't seem to be optimized.
Any ideas?
Thank you
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...