Skip to Main Content

SQL & PL/SQL

can any body explain me this query? select 'alter index '||index_name||' monitoring usage' as inde

kbdevelopersAug 19 2013 — edited Aug 19 2013

Initially i've a put an index of emp table in monitoring state..

later i've got this query

select 'alter index '||index_name||' monitoring usage' as index_monitor from user_indexes where index_name='EMP';

can any body explain me what is the meaning of this query...

and how do that query in the strings of projection area works....

i'm totally confused

thank you in advance.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 16 2013
Added on Aug 19 2013
6 comments
188 views