Table performance, indexing?

2003-02-10 Thread Magnus Själander
Hello I have a performance problem when working against a large table that I hope that I can get some help with. The table stores data that is collected from a monitoring unit for a heating system for a larger house complex. The table is constructed as shown below. Transceiver INT NOT NULL,

Table performance, indexing?

2003-02-10 Thread Magnus Själander
Hello I have a performance problem when working against a large table that I hope that I can get some help with. The table stores data that is collected from a monitoring unit for a heating system for a larger house complex. The table is constructed as shown below. Transceiver INT NOT NULL,