Toad World® Forums

Adding Item into Index

Hi all. I would like to create a script that for each column which is not a primary key, a bitmap index is created and that column is added as an Item into the Index.

Here is the example. I was unable to post the code into the forum because half of the code was removed.
example.js (832 Bytes)

Never mind, I sussed it out.

indexItem = NewIndex.CreateNewObject(2013);
indexItem.SetLinkedObject(“Attribute”, Attribute)

Great! Congratulations!