Printable View
Dead serious so you are :(Quote:
Originally Posted by PAVB
But likewise, the question remains the same.
I was able to completely optimized the SQL without pivot table.
processing 10M+ records from 5minutes down to 15 seconds.
curious are you not?
:)
nah... believe me, I'm not curious about that.
either way, am I good or what? just by hanging around you got smarter and solved the issue LOL
what if you tried
MSG_MESSAGE_TYPE = 'A'
or MSG_MESSAGE_TYPE =2
or MSG_MESSAGE_TYPE =3
or MSG_MESSAGE_TYPE =0
or MSG_MESSAGE_TYPE = 1
Quote:
Originally Posted by ndisang
What part of "I was able to completely optimized the SQL without pivot table.
processing 10M+ records from 5minutes down to 15 seconds." you didn't understand?
Reydp already solved it! :rolleyes:
it was 15 seconds with the autotrace, but to be precise it is only 10 seconds...Quote:
Originally Posted by PAVB
and with high end servers it will only take 5 seconds or less..
blow your mind...:D
problem is in FTS.
If you use this clause
msg_message_type!='0' and msg_message_type!='1'
It's bound to do FTS. Try to use some other predicate.
This is almost 10 million records table and doing FTS, so what you expect?
What's wrong with you guys?Quote:
Originally Posted by malay_biswal
Don't you read the thread before posting?
Are you unable to understand something as basic as "problem already solved?"
I give up :rolleyes:
You better be.HTML Code:I give up
It should be:Quote:
Originally Posted by PAVB
my give up :confused: