Home » RDBMS Server » Server Administration » 10g Express Enable bit-mapped indexes
10g Express Enable bit-mapped indexes [message #216631] Mon, 29 January 2007 14:58 Go to next message
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
Re: 10g Express Enable bit-mapped indexes [message #216651 is a reply to message #216631] Mon, 29 January 2007 17:12 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
From what I've been told, bitmap indexes are not available in XE.
Re: 10g Express Enable bit-mapped indexes [message #216652 is a reply to message #216631] Mon, 29 January 2007 17:17 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
Post results back here -
select index_type, count(*) from dba_indexes group by index_type;
Re: 10g Express Enable bit-mapped indexes [message #216668 is a reply to message #216652] Mon, 29 January 2007 19:48 Go to previous messageGo to next message
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

Re: 10g Express Enable bit-mapped indexes [message #216669 is a reply to message #216631] Mon, 29 January 2007 19:52 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
Since no Bit mapped indexes exist in your DB, then question & answer is moot.
icon13.gif  Re: 10g Express Enable bit-mapped indexes [message #216670 is a reply to message #216631] Mon, 29 January 2007 20:15 Go to previous messageGo to next message
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.
Re: 10g Express Enable bit-mapped indexes [message #216675 is a reply to message #216631] Mon, 29 January 2007 20:42 Go to previous messageGo to next message
BlackSwan
Messages: 25033
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.
icon14.gif  Re: 10g Express Enable bit-mapped indexes [message #216677 is a reply to message #216675] Mon, 29 January 2007 21:24 Go to previous messageGo to next message
MikeOliverAZ
Messages: 4
Registered: January 2007
Junior Member
Thank you, now that was helpful.
Re: 10g Express Enable bit-mapped indexes [message #216680 is a reply to message #216631] Mon, 29 January 2007 21:34 Go to previous messageGo to next message
BlackSwan
Messages: 25033
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.
Re: 10g Express Enable bit-mapped indexes [message #216793 is a reply to message #216631] Tue, 30 January 2007 07:35 Go to previous message
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.
Previous Topic: Storage (next extent)
Next Topic: history table after Update
Goto Forum:
  


Current Time: Sat Dec 03 10:19:39 CST 2016

Total time taken to generate the page: 0.10792 seconds