Subject RE: [firebird-support] Storing Names - or Indexing UDF's
Author Leyne, Sean
> The challenge is searching. Users should be able to type "Smi" and have
> everything from "Smiley Robinson" to "John Smith" to "Adam Smith
> Enterprises" show up. But how to accomplish that with a relatively speedy
> search?

Unless you are storing a list of millions of rows... do nothing!

The Firebird engine does a *very good* job of filtering rows, without the need for an index.

Our application has 1 table which we use for OLAP analysis, it can have 5 million rows and 20 columns, we are able to query that table in 10 seconds without any indexes!

With a smaller the table, with fewer columns, you would easily be able to query is sub 1sec.