Re: IOT Question
Date: Sun, 16 Jun 2002 00:57:34 GMT
Message-ID: <2oRO8.213691$cQ3.7897_at_sccrnsc01>
I would say that depends. If you frequently access this data via a primary
key or some order based upon the primary key then it might be worth while.
Try it and see. 10K to 20K rows is not that much.
Jim
"Vissu" <vissuyk_at_yahoo.com> wrote in message
news:2bedd6a7.0206151635.11affc0b_at_posting.google.com...
> Hi All,
>
> We have few tables that we very frequently in our queries. I am
> thinking of index organizing them. Some tables have multiple columns
> and some have just two columns. The row count in these tables is
> about 10,000-20,000
>
> Is IOT the right data structure, when should it be used ? SHould I
> create more indexes instead on heap organized tables?
>
> Thanks for any help
>
> Vissu
Received on Sun Jun 16 2002 - 02:57:34 CEST