Results 1 to 1 of 1
  1. #1
    Join Date
    Oct 2009

    Unanswered: Viewing FIRST_ROWS of result set before query completes.

    I have a table with 500K rows, then I ad-hoc query with no supported indexing which will require a full table scan. I would like to immediately display the FIRST_ROWS of the result set in one thread while the full table scan continues in another thread. I want to periodically display the query's progress (every 100 rows) example: "SEARCHING 500,000 rows, AT ROW n00, FOUND n, Continue (Y/N)?" while giving the user the option to cancel. This would be a nice time-saving feature, especially since users sometimes don't realize the scope of their queries and would also help avoid runaway-queries (like cartesian products). If I migrate from SE to IDS, I will loose the ability to write low-level functions with c-isam calls, but gain FIRST_ROWS along with other goodies like: SET-READS for index scans (onconfig USE_[KO]BATCHEDREAD), optimizer directives, parallel queries, etc. So if these features are doable, whats the best way to implement them?
    Last edited by informixdev; 04-05-10 at 10:40. Reason: added stuff

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts