Re: spanned indexes

2005-09-15 Thread Michael Stassen
Eli wrote: Gleb Paharenko wrote: You may want to think about the MERGE storage ENGINE, however it doesn't have a real spanned index. See: http://dev.mysql.com/doc/mysql/en/merge-storage-engine.html MERGE is not the case here, since it is JOIN of tables which are different in defintion. M

Re: spanned indexes

2005-09-14 Thread Eli
Gleb Paharenko wrote: You may want to think about the MERGE storage ENGINE, however it doesn't have a real spanned index. See: http://dev.mysql.com/doc/mysql/en/merge-storage-engine.html MERGE is not the case here, since it is JOIN of tables which are different in defintion. MERGE table wou

Re: spanned indexes

2005-09-14 Thread Gleb Paharenko
Hello. No. In the 'CREATE INDEX' syntax only a single table is allowed. You may want to think about the MERGE storage ENGINE, however it doesn't have a real spanned index. See: http://dev.mysql.com/doc/mysql/en/merge-storage-engine.html Eli <[EMAIL PROTECTED]> wrote: > Hi, > > Is

Re: spanned indexes

2005-09-14 Thread Jigal van Hemert
Eli wrote: The reason I thought about this is that I got several tables that hold their own specific data and are indexed inside themselves. But I got an issue to search on JOIN of 2 or more tables with comparison and/or ordering on combinations of fields from the various tables. This usualy

Re: spanned indexes

2005-09-14 Thread Eli
OK.. Thanks for the fast replies.. The reason I thought about this is that I got several tables that hold their own specific data and are indexed inside themselves. But I got an issue to search on JOIN of 2 or more tables with comparison and/or ordering on combinations of fields from the vario

Re: spanned indexes

2005-09-14 Thread Joerg Bruehe
Hi! Eli wrote: Hi, Is it possible, or probably will be possible, to define indexes spanned on more than one table? Short answer: AFAIK, it isn't, and it probably will never be. I mean that if I have column col_a from table tbl_A, and col_b from table tbl_B.. Can I define a KEY with both th

Re: spanned indexes

2005-09-14 Thread Jigal van Hemert
Eli wrote: Is it possible, or probably will be possible, to define indexes spanned on more than one table? I mean that if I have column col_a from table tbl_A, and col_b from table tbl_B.. Can I define a KEY with both those columns? Where will the index be saved? Just out of curiosity and to

Re: spanned indexes

2005-09-14 Thread SGreen
Eli <[EMAIL PROTECTED]> wrote on 09/14/2005 10:13:57 AM: > Hi, > > Is it possible, or probably will be possible, to define indexes spanned > on more than one table? > I mean that if I have column col_a from table tbl_A, and col_b from > table tbl_B.. Can I define a KEY with both those columns?