Sure.

Out of those 14 tables, 8 are used by stored procedures.

I've just gone through all the tables and identified which ones are heaps.

There are > 100, of which 14 have more than 1,000,000 rows :w00t:

4 of them, which...

To assess the possible impact of getting rid of a heap I need to understand how a heap behaves.

So what happens when you do inserts and deletes?

Err, I am on the dev team!

Our SQLIS group are as much use as the proverbial chocolate teapot.

No, scratch that, at least you can eat a chocolate teapot, and these...

The problem is more the impact analysis.

Using the wrong index can seriously screw up responses and we're already in the doghouse with the customers.

The choice of...

That is what is known as a very good idea.

Thanks 😀

Thanks for that. Or no thanks, that wasn't what I wanted to hear!:-)

I guess exporting from production then importing onto the new server would put the data back in...