Re: Utility of indexes

From: Rich M <richmc_at_nospam.net>
Date: 13 Nov 2003 03:20:20 GMT
Message-ID: <2003Nov12.222020.15303_at_jarvis.cs.toronto.edu>

You might try bitmap index.

"Juan Pardillos" <sicotom_at_eresmas.com> wrote in message news:6278687.0311110830.215f56ac_at_posting.google.com...
> Hi,
>
> I have an attribute in a table that I know the number of different
> values it can take is small. However, there are lots of tuples in the
> table. Does it make sense to define an index on that attribute?
>
> Thanks in advance
Received on Thu Nov 13 2003 - 04:20:20 CET

This message: [ Message body ]
Next message: Bob Badour: "Re: Is relational theory irrelevant? (was Re: Dreaming About Redesigning SQL)"
Previous message: Marshall Spight: "Re: Is relational theory irrelevant? (was Re: Dreaming About Redesigning SQL)"
In reply to: Juan Pardillos: "Utility of indexes"
In reply to Juan Pardillos: "Utility of indexes"
Next in thread: Bob Badour: "Re: Is relational theory irrelevant? (was Re: Dreaming About Redesigning SQL)"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message