Hi Again
Why do you know every thing ? :crazy:
And Why am I careless? 😀 :blush:
Yes You Are right. I changed the Index and These are The results : (MeanWhile Last Time my machine was very busy And results were unreal)
In Partition Case :
1 min and 16 sec
In Non Partition Case : (with the same index)
2 min and 22 sec
There are nearly equal . Index was very important.
But at the end :
What was the main purpose of the partitioning? If it couldn't help me in a 300 GB Database, What is the use ?