Home » SQL & PL/SQL » SQL & PL/SQL » Indexing
Indexing [message #240182] Thu, 24 May 2007 05:55 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

Dear friends,

My oracle version is 10 G.
I have a table vactype,this table contains vac id column have null values.i want to create an index in vac id column is possible create index in null vac id column?

Any body help me.

Expecting ur replies..


akkumar81
Re: Indexing [message #240185 is a reply to message #240182] Thu, 24 May 2007 05:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
For B*Tree indexes, if all index columns are null, value is not stored.
For bitmap indexes, null are stored.
You can also create function based index (FBI) with the function you want and so may include nulls (only useful if you use the same expression in your query).

Maybe other things are possible but depends on your final need.

Regards
Michel

Re: Indexing [message #240190 is a reply to message #240182] Thu, 24 May 2007 06:04 Go to previous message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member


ok thanks
Previous Topic: How to call a function? (merged)
Next Topic: Global temporary tables
Goto Forum:
  


Current Time: Fri Dec 09 15:38:38 CST 2016

Total time taken to generate the page: 0.11768 seconds