Michael Ruf wrote:
> Hi, > > i've experienced a mysterious performance problem with MaxDB 7.5.00 26 > > The following statement performs a full table scan when the > subquery returns > no result: > > delete from cx_click where link_id in ( select link_id from > cX_link where > task_id = ? ) > > Is this a bug? > > > regards > Michael Hi, for MaxDB link_id have to be the first or only column of the key or an index to avoid the full table scan in this case. Best regards Holger -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
