Message for Connor McDonald (REF: his reply)

From: Hari Om <hari_om_at_hotmail.com>
Date: 17 Sep 2003 13:03:27 -0700
Message-ID: <d1d5ebe4.0309171203.791dafe6@posting.google.com>

This message is for "Connor McDonald" with reference to his reply @ http://groups.google.co.uk/groups?dq=&hl=en&lr=lang_en&ie=UTF-8&selm=3CC4534C.5DA8%40yahoo.com&rnum=40

I have a question about it. In your reply you gave following example:

---

create table BOEING1 ( x number, y char(100)); create table BOEING2 ( x number, y char(100)); create index BOEING1 on BOEING1 ( x);
create index BOEING2IX on BOEING2IX ( x);

10000 rows inserted into each table, 200 rows for each value of x from 0
to 49. So after running an analyze...

analyze table BOEING1 compute statistics; analyze table BOEING2 compute statistics; etc...

---

what is BOEING2IX in the create index command....?is it a typo....? should it be
BOEING2 instead? Also, what are you trying to show with this example....? It seems that I am lost in your example....could you please explain your point again.

THANKS a MILLIONS!

HARI OM Received on Wed Sep 17 2003 - 15:03:27 CDT