List:General Discussion« Previous MessageNext Message »
From:Jay Blanchard Date:May 8 2002 3:43pm
Subject:RE: INDEXing on MERGED TABLES
View as plain text  
[snip]
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.
[/snip]

Cool, that shaved 2 minutes off of the query time by adding indexes to the
MERGEd table definition where the original tables had indexes.

Thanks!

Jay


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