List:General Discussion« Previous MessageNext Message »
From:Charlie Thunderberg Date:May 8 2002 2:53pm
Subject:Re: INDEXing on MERGED TABLES
View as plain text  
When (or after) creating a merge type table, you do need to create all 
indexes just like you've created them for your regular tables.
This however will NOT result in physically creating any additional indexes, 
but the indexes of the real tables will be used instead.  Therefore no extra 
index maintenance is needed.

Charlie

>From: "Jay Blanchard" <jay.blanchard@stripped>
>To: <mysql@stripped>
>Subject: INDEXing on MERGED TABLES
>Date: Wed, 8 May 2002 09:19:39 -0500
>
>Howdy group!
>
>Having now merged some rather large tables and having read the 
>documentation
>http://www.mysql.com/doc/M/E/MERGE.html "It doesn't need to maintain an
>index of its one. This makes MERGE table collections VERY fast to make or
>remap. Note that you must specify the key definitions when you create a
>MERGE table!. "
>
>It is saying that it "doesn't need" to maintain an index. Does indexing
>effect MERGEd tables?
>
>Thanks!
>
>Jay
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
>To request this thread, e-mail <mysql-thread108353@stripped>
>To unsubscribe, e-mail 
><mysql-unsubscribe-charlie235=hotmail.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>




_________________________________________________________________
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx

Thread
select largestlorin29 Mar
  • RE: select largestStefan Paletta29 Mar
    • Re: Help! Deciding on Java/C++ ?Joel Rees8 May
  • Re: select largestjkraai29 Mar
    • Re: Help! Deciding on Java/C++ ?Gelu7 May
    • Re: Help! Deciding on Java/C++ ?Mark Matthews7 May
    • Encrypted Way to connect to MysqlMarcel7 May
      • Re: Encrypted Way to connect to MysqlIgor Brynskich7 May
      • RE: Encrypted Way to connect to MysqlCal Evans8 May
  • Re: select largestSteve Edberg29 Mar
  • Re: Help! Deciding on Java/C++ ?Gelu7 May
  • Re: Help! Deciding on Java/C++ ?Mark Matthews7 May
  • Re: Help! Deciding on Java/C++ ?Gabriele Bartolini7 May
Re: select largestSteve Edberg29 Mar
RE: Help! Deciding on Java/C++ ?Paul Le7 May
Re: Help! Deciding on Java/C++ ?rup@bigpond.net.au8 May
Re: Help! Deciding on Java/C++ ?Gelu8 May
Re: Help! Deciding on Java/C++ ?Alec.Cawley8 May
Re: Help! Deciding on Java/C++ ?Mark Matthews8 May
Re: INDEXing on MERGED TABLESCharlie Thunderberg8 May
  • RE: INDEXing on MERGED TABLESJay Blanchard8 May
Re: Help! Deciding on Java/C++ ?Gelu8 May
Re: Help! Deciding on Java/C++ ?Frank Morton8 May