Subject Re: [firebird-support] Index
Author Martijn Tonies (Upscene Productions)
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