Reply
Explorer
Posts: 22
Registered: ‎05-22-2016

Phoenix serial range scan problem

Dear all.

 

I'd like to know it is possible to force PARALLEL RANGE SCAN.

 

Now I have execution plan below.

And this plan takes about 10 seconds, So I hope to run this with parallel 80-way range scan.

How can I fix this problem?

 

Help me! Thanks.

 

+-------------------------------------------------------------------------------------------------------------+
| PLAN |
+-------------------------------------------------------------------------------------------------------------+
| CLIENT 80-CHUNK 4683260417 ROWS 377487413197 BYTES SERIAL 80-WAY RANGE SCAN OVER _LOCAL_IDX_DEVICE_HISTORY |
| SERVER FILTER BY FIRST KEY ONLY |
| SERVER 1000 ROW LIMIT |
| CLIENT MERGE SORT |
| CLIENT 1000 ROW LIMIT |
+-------------------------------------------------------------------------------------------------------------+

Announcements