Re: Perfomance Tuning

Posted in 2003

Captain Pedantic — Thu, 11 Dec 2003 20:05:13 -0000 — source: Usenet: comp.databases.informix

"malcolm.iiug" <malcolm.iiug@btopenworld.com> wrote in message news:br9mud$kmo$1@terabinaries.xmission.com... > > Andy and Paul, > You're both wrong in where to start with performance tuning. The first step > must be to learn really well about IDS and how it works. Bollocks. Andy's right on this one. Any DBMS will run shite SQL slowly, for the same reasons. You don't need to know IDS, Oracle or ... er, what's that other IBM database that is never advertised either called? .... er, never mind - to understand why a 100 million row sequential scan will not respond in under a second.