Hi everyone,
I was wondering if any of you know a better way than mine to find the tablespace with the most indexes?
I made this query but maybe it can be done in another way?
SELECT DISTINCT tablespace_name
FROM user_indexes
WHERE tablespace_name IS NOT NULL
AND index_type != 'DOMAIN'
GROUP BY tablespace_name
HAVING COUNT(*) >= (SELECT COUNT(*)
FROM user_indexes
WHERE tablespace_name IS NOT NULL
AND index_type != 'DOMAIN'
GROUP BY tablespace_name
);
Thanks