On Fri, Jan 25, 2002 at 04:02:23PM -0800, Bruce Sandell wrote:
>
> So does this mean that you should or should not bother using indexes
> on a heap table?
You should use an index on a heap table column just like you would for
any other table. It's just that the index isn't a B-Tree like with
MyI
]
Subject: Re: Indexing hash tables
On Fri, Jan 25, 2002 at 03:44:07PM -0800, Bruce Sandell wrote:
>
> Is the index for a hash table stored on disk or in memory?
You mean for HEAP tables, which used hashed indexes?
> I have a hash table that I am constantly adding data to, which means
&g
On Fri, Jan 25, 2002 at 03:44:07PM -0800, Bruce Sandell wrote:
>
> Is the index for a hash table stored on disk or in memory?
You mean for HEAP tables, which used hashed indexes?
> I have a hash table that I am constantly adding data to, which means
> the index is constantly being updated. If I
Sorry, thats a heap table, not a hash table.
-Original Message-
From: Bruce Sandell [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 25, 2002 3:44 PM
To: [EMAIL PROTECTED]
Subject: Indexing hash tables
Is the index for a hash table stored on disk or in memory? I have a hash
table that
Is the index for a hash table stored on disk or in memory? I have a hash
table that I am constantly adding data to, which means the index is
constantly being updated. If I keep the size of the key buffer sufficiently
large, will the new index values be there upon creation, or not until they
are
> From: Karl J. Stubsjoen
> Imagine: a table with over 200,000 records in it and one of
> the fields in
> the table is a keywords field. Keywords seperated by commas.
> The keyword
> field is a collection of keywords that our clients use to identify the
> content of their web pages.
> What we
> From: Karl J. Stubsjoen
> Hello,
>
> Can someone explain hash tables or hash indexes and if we can
> take advantage
> of them in MySQL?
>
> Thanks!
>
> Karl
A few words on a meaty subject...
Hashing is a search method based on an arithmetic or algorithmic
trans
Hello,
Can someone explain hash tables or hash indexes and if we can take advantage
of them in MySQL?
Thanks!
Karl
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
Am 22:21 19.03.2001 schrieb Dave Juntgen:
>*This message was transferred with a trial version of CommuniGate(tm) Pro*
>Hello,
> I would like to ask those of you who have used temporary hash tables in
>MySQL version 2.23.x if you have encountered any problems, concurs or known
>
Hello,
I would like to ask those of you who have used temporary hash tables in
MySQL version 2.23.x if you have encountered any problems, concurs or known
issues. I have been testing it myself and everything sees to working just
fine. Please list your thoughts and comments on temporary hash
10 matches
Mail list logo
