Indices & Packages

  • Thread starter Frosty the Coder
  • Start date

Frosty the Coder

Legendary Poster
I'm being asked to add an index to F4211.
If I add the index, BUT DO NOT GENERATE IT, what happens?

Would this index get generated automagically by the next pkg?

TIA
 
Hi Greg,

It you don't generate nothing will happen apart from specs modification.
Package installation will not physically create your index on DB.

Sebastian
 
Thanks to all who replied.

My goal was to find out just how lazy I could be in the
"need an index AND about to build a package" scenario.

I did my build after the package had completed.

Thanks (again).

Gene
 
When you add a new index to OneWorld table without re-Gen the index, nothing will happen.

If you need an index to improve the DB performance, then you need to re-Gen the index, not table.

If you want to use FetchSingle, for example, in OneWorld event rule to retrieve data from a table and it is not for performance issue, you do not need to generate the new index.

It is totally up to your need.
 
So does this mean if I want to do an "Update" in ER, and need to create an index in table design to facilitate my "where" clause, I can just add the index without generating it?

Does this methodology have any negative impact?
 
That is correct. The Update in ER will generate a SQL statement behind the scene to update the record. If you turn on your debug log, you should see that.

You do not need a real physical index generated on the enterprise server.

The down side is the performance if there are a lot of records in the table, like F0911.
 
Back
Top