13.08.2012 19:15, arnaud le roy wrote: > > it's normal that only the indexes on one table is used during an inner > join ? > > for exemple : > > table a > > ID => pk_index > DATE => index a_date => selectivity : 0.1 > NAME => index a_name selectivity :0.1 > > table b : > > REFIDA => fk_index > REFPRODUIT => index b_produit => selectivity : 0.2 > NAME => index b_name => selectivity : 0.2 > > REQUEST : > > select name from a inner join b on (REFIDA = ID) WHERE a.DATE > > '01.01.2000' and b.name = 'fb_server' and b.refproduit = 'azaza'; > > in the plan analyser only the index of a.date is used (a_date) not the > b.name (b_name) and b.refproduit(b_produit) indexes.
Start with showing us the plan. Dmitry ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
