Hi, as requested in the manual, I set 3 indices on tables 'records'
CREATE INDEX rec_name_index ON records(name); CREATE INDEX nametype_index ON records(name,type); CREATE INDEX domain_id ON records(domain_id); But two indices on the same field are not useful, where will the 'nametype'-index used? Better to create a plain index on type ? Regards Christian -- Christian Kühn (Technical Consultant / Hostmaster) ====================================================== MCS MOORBEK COMPUTER SYSTEME GmbH Essener Bogen 17 - 22419 Hamburg - Germany Tel +49 (0)40 53773 0 - Fax: +49 (0)40 53773 200 eMail: [EMAIL PROTECTED] Web: http://www.mcs.de GPG 8B52 41A1 4B8F 4DE7 9064 2073 6168 137A 3DDA 0F36 ====================================================== _______________________________________________ Pdns-users mailing list [email protected] http://mailman.powerdns.com/mailman/listinfo/pdns-users
