Thank you :)
Von: [email protected] [mailto:[email protected]] Gesendet: Dienstag, 3. März 2015 09:35 An: [email protected] 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> http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! From: mailto:[email protected] Sent: Tuesday, March 03, 2015 9:29 AM To: [email protected] <mailto:[email protected]> 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
