Icon View Incident Report

Serious Serious
Reported By: Danny Humphress
Reported On: 4/29/2005
For: Version 4.19 Build 1
# 2039 Optimization Costs Not Being Calculated Properly for TEXTSEARCH() Queries

I have run across something where I think your query engine is not working optimally. Consider the following query. It is painfully slow on a large database with a text index on Keywords.

SELECT 
  Number
FROM 
  InvMarc
WHERE
  TextSearch(‘FICTION’ IN Keywords)
  AND NOT TextSearch(‘ROMANCE’ IN Keywords)



Comments Comments and Workarounds
The problem is that the full text index does not contain key statistics, but the optimizer was still trying to calculate optimization costs.


Resolution Resolution
Fixed Problem on 5/6/2005 in version 4.20 build 1


Products Affected Products Affected
DBISAM Additional Software and Utilities
DBISAM CLX Client-Server
DBISAM CLX Client-Server with Source
DBISAM CLX Standard
DBISAM CLX Standard with Source
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source

Image