>Thanks Larry,
>
>>If you know the back-end you are working with, you can branch two routes to get this information.
>
>It worked fine for SQL Server, but I'm getting an empty cursor for Oracle, maybe because I don't have access (grant) to the user_indexes table?
>

Fernando,
If you didn't have access to the view (it's a view not a table), you would get a SQL error saying object didn't exist. It's possible there are no indexes for the given table or the WHERE clause doesn't have the correct criteria. Try using LIKE instead of = and see if there results are different.

select * from user_indexes where upper(table_name) like 'MYTABLE%'

HTH.