Re: A thought on Index Organized Tables

<br /><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204);
margin:0pt 0pt 0pt 0.8ex; padding-left: 1ex;">I haven't thought about whether this is sufficient but if it is then<br
/>an initial useful thing to add would be to use it for queries where we<br /> have a qual that can be checked using
theindex key even though we<br /> can't do a range scan. For example if you have a btree index on<br /> <a,b,c>
andyou have a WHERE clause like "WHERE c=0"<br /><br /> That would be a much smaller change than IOT but it would still
bea<br /> pretty big project. Usually the hardest part is actually putting the<br /> logic in the planner to determine
whetherit's advantageous. I would<br /> suggest waiting until after 9.0 is out the door to make sure you have<br /> the
attentionof Heikki or Tom or someone else who can spend the time<br /> to check that it will actually work before
puttinglots of work coding<br /> it.<br /><br /></blockquote></div>I will try that. Thanks ...<br />