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 Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! From: mailto:[email protected] Sent: Tuesday, March 03, 2015 9:29 AM To: [email protected] 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
