Seagate Designer - View of Database Indexing 1

[TopJack]

I'm using Info Designer 8.0 to view a table from an ERP system (Oracle setup). The table seems to have a default index. I know within the database there is two other alternative indexes. How do I use these alternative indexes ?

Thanks in advance.

 

[Naith]

You usually don't have to prompt the database optimiser for index utilisation. The database will automatically utilise these indices if the database thinks it's the most logical way to obtain the data.

So, if the index is made up of 3 fields, but you're only selecting 2 of the 3, then the index won't be used.

If you want to force the query to use the index, then you'll have to use SQL or a stored procedure as your datasource. Alternatively, you could select the remaining field that you don't need so that all requirements for the secondary index is met - and so it'll be used. Naturally, you'd want to suppress the extra field.

All the best,

Naith

 

[TopJack]

Absolutely perfect. I have added a field to the report that I do not want to see (I surpress it) but is part of an alternative index and the report now runs 10 times faster. Selecting all three fields in an index allows Seagate to optimise the running.

Thanks a million Naith.