keys is. The only requirement is that the column be
low-cardinality.
It basically works like this:
true 01101
false 10010
One bitmap is stored for each possible value of the column. In this
case the false bitmap shows that the first and fourt
ing a BITMAP index,
like Oracle. They're perfect for indexing boolean true/false columns or
any column that has a small number of possible values.
--
Daniel Koch <[EMAIL PROTECTED]>
-
Before posting, please check
Don Vu wrote:
Hi guys,
I have a script in my home directory that i want others to be able to run. I 'chmod 777'ed the file and the folder it lives in and people still can't run it when they are at the mysql prompt and type "source /path/to/script/scriptname.sql". I can execute that script, even
On Mon, 2002-10-07 at 10:30, Jeremy Tinley wrote:
> Howdy,
>
> There has been some interest lately in HA of MySQL services both in my
> company and on the list. A few of us here sat down on Friday (at 5PM no
> less) and started hashing out the details of providing such a service.
> Following sev
On Fri, 2002-07-26 at 05:17, Corey Wallis wrote:
> Peoples,
>
> I'm currently trying to work out if this is possible by SQL. I have the need
> to use SQL and only SQL to achieve the following.
>
> If a record exists and meets a certain criteria (i.e. field X = '1234') then
> update the record.
Arul wrote:
>Hi
>
>Any idea when MySQL 4.0 stable release will be made..
>As of now only Alpha is released..
>
>Also any sites which run on 4.0 Alpha
>
>
>
4.0.1 has been very stable for us:
[root@db1 root]# mysqladmin version
mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for pc-linux-gnu on i6