Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005
    Posts
    5

    Unanswered: Low Isql Ids Compare To Se Engine

    I do a SELECT COUNT(*) FROM table for 500 tables.

    On the isql SE ENGINE V5 : 10sec
    On the isql IDS 9.4 ENGINE : 30minutes !!!!!!!!!!!!!!!!!!!!

    How can I explain this bad duration ?

  2. #2
    Join Date
    Oct 2005
    Posts
    2
    Did you run "UPDATE STATISTICS" after you populated the tables ?

Posting Permissions

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