View Incident Report

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 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

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

Products Affected

DBISAM Additional Software and Utilities
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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap