searching performance ?

From: Michael Henderson <MHenders_at_tvnz.co.nz>
Date: Thu, 21 Sep 2000 13:44:33 +1200
Message-Id: <10625.117520@fatcity.com>

Hi all,

Does anyone have any ideas or comments about performance with using search = conditions on single word columns as opposed to multiple word columns ? = Is there any overhead involved in either setup ? Indexes wouldn't get = used for search operations (except whole word matches in single word = column), right ?

Any help would be appreciated.

Regards,
Mike.

Michael Henderson, DBA
http://www.nzoom.com
DDI: +64-9-916 6941 Fax: +64-9-308 9614 Mob: 021-465 466 Received on Wed Sep 20 2000 - 20:44:33 CDT