mysql 查询优化问题

[起个好昵称怎么这么难呢]

两个表联合查询效率问题
1.
查询 SELECT citedocid from doccitedoc a,(select docid from aureldoc where auid='5280272d936a8501a4870ced') b where a.docid=b.docid
分析
2.
查询 select citedocid from doccitedoc where docid in ('52835013395c93f76cdae195',
'528345c3395c93f76cc8ec1c',
'52838c2c395c93f76c4552c2',
'52838c2d395c93f76c45533e',
'52838c2d395c93f76c45541e',
'52838c2b395c93f76c4550cd',
'528328e193c2a29fc8d94645',
'528328e193c2a29fc8d94647',
'528328e093c2a29fc8d943a1',
'528328e493c2a29fc8d94d49',
'528328e593c2a29fc8d94ef7',
'528328e193c2a29fc8d9469f',
'528328e493c2a29fc8d94cf6',
'528328e093c2a29fc8d9451a',
'528328e193c2a29fc8d94646',
'528328e293c2a29fc8d94990',
'528328e593c2a29fc8d94f63',
'528328e593c2a29fc8d95082',
'52833f2b395c93f76cbe6d02',
'52838c2b395c93f76c4550be',
'52838c2d395c93f76c45532b',
'52838dde395c93f76c484487',
'52839113395c93f76c4e2021',
'52839115395c93f76c4e2213',
'52838c2c395c93f76c455113',
'52838c2a395c93f76c454dc8',
'5284f9350cc89dbd4d78744b',
'5284585c0cc89dbd4df74e38',
'5284f0280cc89dbd4d73cad0',
'5284ff5c0cc89dbd4d7ba2a1',
'5285018d0cc89dbd4d7cba6e',
'5284adff0cc89dbd4d45ecfb',
'5284dc1d0cc89dbd4d67ad24',
'528478250cc89dbd4d0a56b9',
'528478ce0cc89dbd4d0afa27',
'5284edc90cc89dbd4d726813',
'5284adff0cc89dbd4d45ed07',
'5284f1eb0cc89dbd4d74afa8',
'5284f28b0cc89dbd4d750b3b',
'52847e650cc89dbd4d119d1c',
'5284f84e0cc89dbd4d77f1cf',
'528485b70cc89dbd4d17f637',
'5284eeee0cc89dbd4d7318a9',
'5284f0280cc89dbd4d73cae7',
'52838c2b395c93f76c45505f',
'528485b70cc89dbd4d17f667',
'5284f68b0cc89dbd4d771669',
'528501350cc89dbd4d7c8257',
'528502200cc89dbd4d7d121e',
'52849ea50cc89dbd4d336c35',
'5284e97c0cc89dbd4d701841',
'5284e97c0cc89dbd4d701860',
'5284eb5b0cc89dbd4d71171f',
'5284585d0cc89dbd4df74ec8',
'528485b60cc89dbd4d17f5bc',
'5284ac340cc89dbd4d43e16b',
'528488210cc89dbd4d1ad05c',
'5284792d0cc89dbd4d0b677a'
)
分析：
3.
查询： select a.* from doccitedoc a inner join aureldoc b on a.docid = b.docid where auid='5280272d936a8501a4870ced'
分析：


说明：aureldoc表说明
docid 和auid 都有索引，索引类型normal 索引方式BTREE
doccitedoc表
docid 有索引 索引类型normal 索引方式BTREE
这三种方法中，第二种方法效率最高但是这样写特别麻烦，大家有什么好的方法吗

[起个好昵称怎么这么难呢]

别沉下去了，大家帮忙看看

[rucypli]

doccitedoc a force index (docid上的索引)

[rucypli]

select a.* from doccitedoc a force index (docid上的索引) inner join aureldoc b force index(auid上的索引) on a.docid = b.docid where auid='5280272d936a8501a4870ced'

[起个好昵称怎么这么难呢]

引用 2 楼 rucypli 的回复:

select a.* from doccitedoc a force index (docid上的索引) inner join aureldoc b force index(auid上的索引) on a.docid = b.docid where auid='5280272d936a8501a4870ced'

select a.docid from doccitedoc a force index (docid_index) inner join aureldoc b force index(auid_index) on a.docid = b.docid where auid='5280272d936a8501a4870ced'
效率还是不高