🚀 go-pugleaf

In article <3ddd565d$1@newsgroups.borland.com>, nkarasev@e-dn.com says...
> However, in this case MSSQL is a lot more stable and what's more important
> alot faster than Interbase.
> 
	You need to understand how IB's indices work.

	IB string indices work from the beginning of the string forward.  
They're not useful for locating substrings in the middle of a string 
field.  So if you're searching for a substring at the beginning of a 
string field, you need to make sure that IB knows this.  You can use 
STARTING WITH instead of like (no wildcards in STARTING WITH), or you can 
use LIKE with a constant expresssion and no wildcard at the beginning.  If 
you use LIKE with a parameter, however, IB doesn't know whether you're 
looking for a constant, a substring with a wildcard at the end, or a 
substring with a wildcard at the beginning, so the optimizer won't be able 
to specify the use of the index.

	*When an index is used* IB should be comparable to SQL Server on 
similar hardware in this case.  If SQL Server is using an index and IB is 
not, then of course SQL Server will be faster.

	-Craig

-- 
Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH
Delphi/InterBase Weblog : http://delphi.weblogs.com
InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor
InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer