Who can do that is awesome! Execute a sql query, you can do multiple threads in parallel?

Users questions:I have a record of more than 4,000 million table tb_order, which has field order_id and order_num I use SQL query device, enter select * fromtb_order, crash phenomenon appeared. (In fact, the amount of data too large) canQuery using multiple threads in parallel, to reduce running time? Also if my machine is 8 CPU's. Is it possible to achieve it?
Experts answer:select * from (selectorder_id, order_num, row_number () over (orderbyorder_idasc) rnfromtb_order) whererbbetween? and?
  • This information provided by the users.Thanks!