Hi,
I am using 11g r2. My appl response was slow so i see the table and all partitioned indexes were missing from a table. When i created the index it gives error that the column is already indexed. But I cannot see the indexes. So I login with sys and astonished to see that tables was indexed with index owner sys. How there owner is changed from schema to sys. And if there owner was sys from the day one then why SQL tunning advisor is recommending now to index those columns.
Thanks