Re: Indexes

[<ma...@li...>]

Ho-Sheng,

All SQL-based RDBMS systems use indexes, and use them in essentially the
same manner (from the DBA's point of view).

If SQL-Ledger isn't supplying indexing for tables and relations, it's
just a bug.  (Dieter?)  It does look like my 1.6.1 setup is missing a lot
of obvious foreign keys/indexes.

You might supply the SQL statements (CREATE INDEX) you developed to the
list, as it sounds like this would help people.

Matt

On Sun, 6 Jan 2002, Ho-Sheng Hsiao wrote:

> On Sun, Jan 06, 2002 at 11:26:33AM +0100, Roland Stoker wrote:
> > Ehhh guys????
> >
> > Indexes makes search-queries go from O(n) to O log(n)
> > Read O as order
> > That's about the biggest performance difference you can get in a database!!!!!
>

-- 

Matt Benjamin

The Linux Box
206 South Fifth Ave. Suite 150
Ann Arbor, MI  48104

tel. 734-761-4689
fax. 734-769-8938
cel. 734-216-5309
pgr. 734-431-0118