diff --git a/init.go b/init.go
index 57213b1..107f5be 100644
--- a/init.go
+++ b/init.go
@@ -155,6 +155,9 @@
     status text,
     PRIMARY KEY (appcred_id, app_id, apiprdt_id,tenant_id)
 );
+CREATE INDEX developer_id ON developer (id);
+CREATE INDEX api_product_id ON api_product (id);
+CREATE INDEX app_id ON app (id);
 `)
 	if err != nil {
 		log.Panic("Unable to initialize DB", err)