Suppose I have a table with 6 INTEGER columns, and 600k entries. I need to create a unique index on three of those columns, ie., CREATE UNIQUE INDEX loc ON data (x,y,z). That takes a while so I thought I'd show some progress. >From that information, is it possible to calculate the number of opcodes such an operation would require for completion so that I could get an accurate progress bar? Is there a query that would tell me how many opcodes it would take? Is it possible to create the index once and count the number of opcodes and do they grow linearly in the creation of indexes?
Thanks again, ______________________________ Brannon King ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
