oh sorry but i post here because i have a doubt that this behaviour it's not normal but effectively it's not the good mailing list.
my test are done on 2.5 super server on windows 7 64. in this little test there is 10000 lines in each table but in my real database i have one milliom lines and six millions lines and i obtain the same result. Le 13/08/2012 19:55, Ann Harrison a écrit : > > > On Mon, Aug 13, 2012 at 11:15 AM, arnaud le roy <sdnetw...@gmail.com > <mailto:sdnetw...@gmail.com>> wrote: > > > it's normal that only the indexes on one table is used during an inner > join ? > > > No, but this is a support question, not a developer question, and should > be sent to firebird-supp...@yahoogroups.com > <mailto:firebird-supp...@yahoogroups.com>. When you send your question > there, please include the plan that Firebird generated and the > approximate number of records in each table. > > Good luck, > > Ann > > > ------------------------------------------------------------------------------ > 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 > ------------------------------------------------------------------------------ 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
