I have two large databases(2.7 million entries each) which need to be merged and sorted .
The sorting of merged table consumes a lot of time when done by order by.
Is there any other way to sort this merged table faster?
I have already tried indexing which speeds up the execution but i'm looking for more speed
If anyone can help.Thanks