OraFAQ Forum: Server Administration » 10g Express Enable bit-mapped indexes

Home » RDBMS Server » Server Administration » 10g Express Enable bit-mapped indexes

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

10g Express Enable bit-mapped indexes [message #216631]

Mon, 29 January 2007 14:58

MikeOliverAZ
Messages: 4
Registered: January 2007

Junior Member

is it possible to enable bit-mapped indexes on 10g Express?

I see in the settings two values for bit-mapped area size so that hints at support for them but I cannot find documentation on how to enable them if you can. Razz

Report message to a moderator

Re: 10g Express Enable bit-mapped indexes [message #216651 is a reply to message #216631]

Mon, 29 January 2007 17:12

ebrian
Messages: 2794
Registered: April 2006

Senior Member

From what I've been told, bitmap indexes are not available in XE.

Report message to a moderator

Re: 10g Express Enable bit-mapped indexes [message #216652 is a reply to message #216631]

Mon, 29 January 2007 17:17

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Post results back here -
select index_type, count(*) from dba_indexes group by index_type;

Report message to a moderator

Re: 10g Express Enable bit-mapped indexes [message #216668 is a reply to message #216652]

Mon, 29 January 2007 19:48

MikeOliverAZ
Messages: 4
Registered: January 2007

Junior Member

INDEX_TYPE COUNT(*)
IOT - TOP 52
LOB 570
FUNCTION-BASED NORMAL 15
FUNCTION-BASED DOMAIN 1
NORMAL 1929
CLUSTER 10
DOMAIN 2

Report message to a moderator

Re: 10g Express Enable bit-mapped indexes [message #216669 is a reply to message #216631]

Mon, 29 January 2007 19:52

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Since no Bit mapped indexes exist in your DB, then question & answer is moot.

Report message to a moderator

Re: 10g Express Enable bit-mapped indexes [message #216670 is a reply to message #216631]

Mon, 29 January 2007 20:15

MikeOliverAZ
Messages: 4
Registered: January 2007

Junior Member

Well moot, thanks for nothing since I asked how to enable bit-mapped indexes it they can, which by asking means none are enabled and I wouldn't expect any to exist.

Kindly go find someone else to impress with your clever wit and leave us adults to ask and answer questions.

Report message to a moderator

Re: 10g Express Enable bit-mapped indexes [message #216675 is a reply to message #216631]

Mon, 29 January 2007 20:42

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

An index can exist & be disabled.
The only way to ENABLE an index is for it to exist & be disabled.
If you want to create a Bit mapped index you should read the fine SQL Reference manual in particular the CREATE INDEX section found here:
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_5010.htm#sthref6509
By default when an index is created it is ENABLED unless the SQL states otherwise.

Report message to a moderator

Re: 10g Express Enable bit-mapped indexes [message #216677 is a reply to message #216675]

Mon, 29 January 2007 21:24

MikeOliverAZ
Messages: 4
Registered: January 2007

Junior Member

Thank you, now that was helpful.

Report message to a moderator

Re: 10g Express Enable bit-mapped indexes [message #216680 is a reply to message #216631]

Mon, 29 January 2007 21:34

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Rarely is a bit mapped index the silver bullet to a performance problem.
Previously a bit mappped index would send performance into a tar pit when placed on a a table that got heavy INSERT activity.
I have not tested recent Oracle versions to see if they have fixed this bug.

Report message to a moderator

Re: 10g Express Enable bit-mapped indexes [message #216793 is a reply to message #216631]

Tue, 30 January 2007 07:35

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

The last time I read the licensing documentation (which changes, so I could be out of date), bitmaps were considered an enterprise edition only feature, which means they would not be possible in XE.

If you don't mind, try creating one and posting here a log of your attempt and the results. I don't have an XE to test on.

Report message to a moderator

Previous Topic:	Storage (next extent)
Next Topic:	history table after Update

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 13:32:25 CDT 2024