[Pdns-users] Index for PDNS in Mysql

[Christian Kuehn]

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: christian.kuehn at mcs.de
Web: http://www.mcs.de
GPG 8B52 41A1 4B8F 4DE7 9064  2073 6168 137A 3DDA 0F36
======================================================