Subject AW: [firebird-support] Index
Author checkmail

Thank you J


Von: []
Gesendet: Dienstag, 3. März 2015 09:35
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

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!



Sent: Tuesday, March 03, 2015 9:29 AM

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