|Subject||AW: [firebird-support] Index|
Thank you J
A combined index, with the field that has the largest number of different values as the first indexed field.
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
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?