Thank you :)
Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Dienstag, 3. März 2015 09:35 An: firebird-support@yahoogroups.com Betreff: Re: [firebird-support] Index Hello Olaf, A combined index, with the field that has the largest number of different values as the first indexed field. With regards, Martijn Tonies Upscene Productions <http://www.upscene.com> http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! From: mailto:firebird-support@yahoogroups.com Sent: Tuesday, March 03, 2015 9:29 AM To: firebird-support@yahoogroups.com <mailto:firebird-support@yahoogroups.com> Subject: [firebird-support] Index Hello everybody, I’m looking in a table for an existing record bevore I insert it. Now I would set some indices. There are 4 fields I compare… It is better I create one index with all 4 fields or for every field one? Thank your Olaf