索引损坏了连接表中的备注字段 [英] Index corrupts memo-field in joined table

问题描述

为了解决性能问题，我在表 A 中添加了一个索引.该表在查询中与表 B 相连.添加索引会破坏表 B 中备注字段的输出.当我删除索引时，一切又好了.

to address performance issues I added one index in table A. This table is joined inside a query with table B. Adding the index corrupts the output of memo fields in table B. When I remove the index all is fine again.

希望我说清楚了，如果有兴趣，我可以添加有关查询本身的更多信息.

Hope I made myself clear, if interested I could add some more information about the query itself.

对此有什么想法吗?

干杯，拉蒙

推荐答案

这个问题似乎与处理备注字段的常见错误有关.当我将查询功能从group by"更改为first"时，如此处所示 http://allenbrowne.com/bug-18.html 一切正常.

It seems that this issues is related to common errors on handling memo fields. When I change the query function from "group by" to "first", like demonstrated here http://allenbrowne.com/bug-18.html it all works fine.

奇怪的是，错误仅在我添加索引后发生.

Strangely enough the error occurred only after I add an index.

拉蒙

这篇关于索引损坏了连接表中的备注字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！