开发者

What to grant to user to use index of table while querying?

I want 开发者_如何学JAVAto know if oracle uses index when user queries data from table and that user has been granted just:

grant select on table to user

I want to know if it is needed some another grant to use index.


No, there is no requirement (or ability) to grant access to an index. If the user can access the table then their queries can use any available index.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜