It's not clear from your description: - what you'd consider a "good" query time for such (or equivalent) query returning 100M rows - how quickly your client can receive 100M rows of the result (i.e for example how long it'll take - using the same client - to do SELECT serialno , pid fcid, pid+100 lc...