| Subject | Re: [firebird-support] Index |
|---|---|
| Author | Martijn Tonies (Upscene Productions) |
| Post date | 2015-03-03T08:35:12Z |
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!
Martijn Tonies
Upscene Productions
http://www.upscene.com
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
Olaf