3,490
社区成员
发帖
与我相关
我的任务
分享
最好使用这样的语法结构:
begin
dbms_stats.gather_table_stats
( ownname => user,
tabname => 'tablename',
method_opt => 'for all indexed columns',
cascade => TRUE );
end;
SELECT endpoint_number, endpoint_value,ENDPOINT_ACTUAL_VALUE
FROM(
SELECT endpoint_number, endpoint_value,ENDPOINT_ACTUAL_VALUE
FROM USER_HISTOGRAMS
WHERE table_name = 'tablename' and column_name = 'OWNER'
ORDER BY endpoint_number)
WHERE rownum <=20;