最初建设乐酷的数据库时，由于语法的不同，所以省略了所有的索引命令，前两天终于发现，数据量大了以后，数据库检索起来非常耗费服务器资源。索性，今天晚上把原来建库时的索引归纳了一下，统一记载在这里以备不时之需。
create index uidstart on cdb_activities(uid,starttimefrom);
create index uidtid on cdb_activityapplies(uid,tid);
create index tiddateline on cdb_activityapplies(tid,dateline);
create index startend on cdb_announcements(starttime,endtime);
create index tiduidindex on cdb_attachments(tid,uid);
create index pidaid on cdb_attachments(pid,aid);
CREATE INDEX attachmentindex ON cdb_attachments (tid, pid);
create index authid on cdb_attachpaymentlog(authorid);
create index typeexpiration on cdb_caches(type,expiration);
create index nextruntid on cdb_campaigns(nextrun,tid);
create index nextrunavail on cdb_crons(available,nextrun);
create index pidstand on cdb_debateposts(pid,stand);
create index debatepoststiduid on cdb_debateposts(tid,uid);
create index debatesuidstart on cdb_debates(uid,starttime);
create index displayplayid on cdb_faqs(displayorder,id);
create index displayorderid on cdb_forumrecommend(fid,displayorder);
create index forumtype on cdb_forums(status,type,displayorder);
create index fupfid on cdb_forums(fup,fid);
create index invitecodeuid on cdb_invites(invitecode,uid);
create index targetuiddate on cdb_magiclog(targetuid,dateline);
create index magicnum on cdb_magicmarket(magicid,num);
create index magicprice on cdb_magicmarket(magicid,price);
create index magicuid on cdb_magicmarket(magicid,uid);
create index avadisplayorder on cdb_magics(available,displayorder);
create index uidemail on cdb_members(uid,email);
create index uidgroupid on cdb_members(uid,groupid);
CREATE INDEX usrindex ON cdb_members (uid, password, secques);
create index uiddate on cdb_modworks(uid,dateline);
create index mypoststiddate on cdb_myposts(tid,dateline);
create index mythreadstiddate on cdb_mythreads(tid,dateline);
create index subdate on cdb_orders(submitdate);
create index subuid on cdb_orders(uid,submitdate);
create index payloguid on cdb_paymentlog(uid);
create index paylogauthorid on cdb_paymentlog(authorid);
create index pluginid on cdb_pluginhooks(pluginid);
create index available on cdb_pluginhooks(available);
create index pluginvarsid on cdb_pluginvars(pluginid);
create index pmsmsgtoid on cdb_pms(msgtoid,folder,dateline);
create index msgfromid on cdb_pms(msgfromid,folder,dateline);
create index polltid on cdb_polloptions(tid,displayorder);
create index postsfid on cdb_posts(fid);
create index postsauthorid on cdb_posts(authorid);
create index postsdate on cdb_posts(dateline);
create index postsinvi on cdb_posts(invisible);
create index postsorder on cdb_posts(tid,invisible,dateline);
create index postsfirst on cdb_posts(tid,first);
create index profava on cdb_profilefields(available,required,displayorder);
create index ratepid on cdb_ratelog(pid,dateline);
create index ratedate on cdb_ratelog(dateline);
create index regip on cdb_regips(ip);
create index rewuserid on cdb_rewardlog(authorid,answererid);
create index rssfid on cdb_rsscaches(fid,dateline);
create index sessuid on cdb_sessions(uid);
create index sessbloguid on cdb_sessions(bloguid);
create index styleid on cdb_stylevars(styleid);
create index tagtotal on cdb_tags(total);
create index tagclosed on cdb_tags(closed);
create index threads_digest on cdb_threads(digest);
create index threads_displayorder on cdb_threads(fid,displayorder,lastpost);
create index threads_blog on cdb_threads(blog,authorid,dateline);
create index threads_typeid on cdb_threads(fid,typeid,displayorder,lastpost);
create index threadsmod_tid on cdb_threadsmod(tid,dateline);
create index threadsmod_expiration on cdb_threadsmod(expiration,status);
create index threadtags_tagname on cdb_threadtags(tagname);
create index threadtags_tid on cdb_threadtags(tid);
create index trade_raterid on cdb_tradecomments(raterid,type,dateline);
create index trade_rateeid on cdb_tradecomments(rateeid,type,dateline);
create index trade_orderid on cdb_tradecomments(orderid);
create index tradelog_sellerid on cdb_tradelog(sellerid);
create index tradelog_buyerid on cdb_tradelog(buyerid);
create index tradelog_status on cdb_tradelog(status);
create index tradelog_buyerlog on cdb_tradelog(buyerid,status,lastupdate);
create index tradelog_sellerlog on cdb_tradelog(sellerid,status,lastupdate);
create index tradelog_tid on cdb_tradelog(tid,pid);
create index tradelog_pid on cdb_tradelog(pid);
create index tradeopvar_typeid on cdb_tradeoptionvars(typeid);
create index tradeopvar_pid on cdb_tradeoptionvars(pid);
create index trades_sellerid on cdb_trades(sellerid);
create index trades_totalitems on cdb_trades(totalitems);
create index trades_tradesum on cdb_trades(tradesum);
create index trades_displayorder on cdb_trades(tid,displayorder);
create index trades_sellertrades on cdb_trades(sellerid,tradesum,totalitems);
create index trades_typeid on cdb_trades(typeid);
create index typeoptions_classid on cdb_typeoptions(classid);
create index typeoptionvars_typeid on cdb_typeoptionvars(typeid);
create index typeoptionvars_tid on cdb_typeoptionvars(tid);
create index typevars_typeid on cdb_typevars(typeid);
create index usrgroup_credit on cdb_usergroups(creditshigher,creditslower);
create index validat_status on cdb_validating(status);
create index videos_date on cdb_videos(dateline);
create index videotags_tid on cdb_videotags(tid);
CREATE INDEX vod_date ON cdb_vodlist(createdate, author);
CREATE INDEX vod_recopubl ON cdb_vodlist(recommend, published);
CREATE INDEX vod_publ ON cdb_vodlist(published);
create index vod_cate on cdb_vodlist(cate);
create index vod_fid on cdb_vodlist(fid);
评论