I thought I had already posted this query but now I can't remember. If
I have please excuse the repeat. But as I can't remember the answer
either can someone please comment.
Is there likely to be any attempt to allow a table to be keyed. It
seems that by default a table is created as a heap and in order to
improve access speed, one must create indices on that table.
I use Ingres at work and quite like the ability to do a 'modify table to
btree' type of command. When the table concerned is basically only a
key plus value, it seems rather inefficient to have to have both the
heap and then an index when supposedly one could simply make the table
into a btree in the first place.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Glen Eustace, on behalf of
GodZone Internet Services, a division of AGRE Enterprises Limited.
176 Te Awe Awe St, Palmerston North, New Zealand
Ph: +64 6 356 2562, Fax: +64 6 357 0271, Mobile: 025 416 184,
http://WWW.GodZone.Net.NZ