Message-Id: <10547.111089@fatcity.com> From: "Andrey Bronfin" Date: Mon, 3 Jul 2000 11:22:37 +0200 Subject: Indexes question This is a multi-part message in MIME format. ------=_NextPart_000_0327_01BFE4E0.FDD81FB0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear DBAs ! I'm having a very strange situation here , so i just must have your help = . There is a table URLS , which has a column URL of type varchar2(740) . I have a single-column index URL_IX defined on that column . Now , by querying the DBA_EXTENTs , i see that the index URL_IX occupies = more space ( bytes , blocks , extents ) than the table itself . Is it a normal situation ? Is it effective to define such an index on a varchar2 (740) column and = search it ? Is there a more effective way to index such a column and to optimize the = access to it ? Thanks a lot in advance ! Andrey Bronfin VisualTop.com +972-3-5275757. ------=_NextPart_000_0327_01BFE4E0.FDD81FB0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Dear DBAs !

I'm having a very strange situation = here , so i=20 just must have your help .

There is a table URLS , which has a = column URL of=20 type varchar2(740) .

I have a single-column index URL_IX = defined on that=20 column .

Now , by querying the DBA_EXTENTs , i = see that the=20 index URL_IX occupies more space ( bytes , blocks , extents ) than the = table=20 itself .

Is it a normal situation ?

Is it effective to define such an index = on a=20 varchar2 (740) column and search it ?

Is there a more effective way to index = such a=20 column and to optimize the access to it ?

Thanks a lot in advance !

Andrey=20 Bronfin
VisualTop.com
+972-3-5275757.