| Subject | AW: [firebird-support] Index |
|---|---|
| Author | checkmail |
| Post date | 2015-03-03T20:01:58Z |
Thank you J
Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Dienstag, 3. März 2015 09:35
An: firebird-support@yahoogroups.com
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
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