开发者

how to receive fast result from access query?

i have table (MyTbl) that has 3 field's A,B,C

this table contain 800000 records.

what is the best way to receive fast result ?

开发者_JAVA百科

i try this:

select top 1 A from MyTbl where A='123'

but it isn't fast

i work with Access 2007 - and C# program


Create an index on the column A in MyTbl.


Create an index on table MyTbl, field A.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜