"Andreas Ntaflos" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > CREATE TABLE Room ( > room_number INTEGER PRIMARY KEY AUTOINCREMENT, > building_id INTEGER CONSTRAINT fk_room_building_id REFERENCES > Building(building_id) ON DELETE CASCADE > ); > > CREATE UNIQUE INDEX idx_building_room ON TABLE Room(room_number, > building_id);
This index has no benefit whatsoever. It only adds performance overhead. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
