问题3

如何查看表 mytab 有哪些索引？

•  A show indexes;

•  B show indexes for mytab;

•  C select \* from sysindexes where tabname='mytab';

•  D select \* from sysindexes where tabid in(select tabid from systables where tabname='mytab');