MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » December 2012

Re: Aldon & Index Advisor Indexes



fixed

Jim,

Yes, I know about generating the SQL--sorry I didn't make that clear. In fact, I had just gone through the exercise of tweaking one into what Aldon LMi expects as pseudo code, which caused me to post the question.

I'm trying to talk myself into no source...

If I forget about source, and let Index Advisor create the index, I can then just use the Aldon LMi load facility to enroll them in Aldon as non-source objects. Aldon will them always keep track of them as dependent objects as needed and promote them through the environments for me.

If I need to change one, I check it out, which means I have an empty index in my checkout library. Then I use the iNav GUI to alter the index (hmmm - I haven't tried that on a index) and then let Aldon take care of the promotion and distribution.

This seems like less work to me. Only downside I see is that I have to educate my co-workers on how this works.

Maybe someone else can pick holes in this approach.

Sam

On 12/4/2012 6:49 AM, Jim Oberholtzer wrote:
Sam,

Instead of having index adviser create the index for you, use the "Show
SQL" option in the drop down(At V7 it's the third item)





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact