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 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? > > -thanks. > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]