Skip to Content
avatar image
Former Member

Sample 10 PERCENT Question

Hello Everybody

I want do do an:

"Update table xyz SAMPLE 10 PERCENT "

for my big tables.

Do i have to fire this command for each wanted table or does an:

"update table set sample_rows = .NULL.,sample_percent = 10 where ..."

lead to the same result.

Best regards

Albert

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Feb 20, 2008 at 12:46 PM

    Sorry

    Of course it has to be:

    Alter table xyz sample 10 PERCENT

    Add comment
    10|10000 characters needed characters exceeded