Hi John, Many thanks for speedy response. At the moment, my data entry form is based on the (single) table. To get it to automatically display records in sorted order, I should create a query and base the form on that?
Bob On Friday 18 September 2009 19:14:00 jomali wrote: > Hi, Bob, > > Generally, you can have as many as you need. > > No, you don't have to delete your ID index. In fact, you have to have a > primary index in order to enter any data at all. > > All additional indexes (indices?) do is to make ordering faster when you > order on the index parameters. For a name and address database, with only a > few records (less than thousands) you are unlikely to experience any > performance improvements by creating additional indexes. > > Unless you are processing many records at a time many times a day, don't > bother making additional indexes. Just use ORDER BY clauses in your sql > statements and be done with it. > > John > > On Fri, Sep 18, 2009 at 1:59 PM, Bob Williams > > <li...@barrowhillfarm.org.uk>wrote: > > Hi, > > > > How many indexes can a database have? I have created a simple, flatfile, > > name > > and address type database. Each entry has an auto-incremented ID number, > > which > > was set as the primary index in the design stage. Now that I've got some > > records in there, I'd like to index it on Lastname then Firstname in A-Z > > ascending order. Do I have to delete the ID index, which is called > > SYS_IDX_46, > > first? Will this activate my new 'Names' index automagically? > > > > Thanks, > > > > Bob > > -- > > Registered Linux User #463880 FSFE Member #1300 > > GPG-FP: A6C1 457C 6DBA B13E 5524 F703 D12A FB79 926B 994E > > openSUSE 11.1, Kernel 2.6.27.25-0.1-default, KDE 4.3 > > Intel Core2 Quad Q9400 2.66GHz, 4GB DDR RAM, nVidia GeForce 9200GS > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: users-unsubscr...@openoffice.org > > For additional commands, e-mail: users-h...@openoffice.org > -- Registered Linux User #463880 FSFE Member #1300 GPG-FP: A6C1 457C 6DBA B13E 5524 F703 D12A FB79 926B 994E openSUSE 11.1, Kernel 2.6.27.25-0.1-default, KDE 4.3 Intel Core2 Quad Q9400 2.66GHz, 4GB DDR RAM, nVidia GeForce 9200GS --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org