The relevant query is as follows:
SELECT index_name
FROM all_indexes
WHERE table_name = ‘<TABLE_NAME>’;
End to End Topics With SQL,PL/SQL,Reports,Forms,XML Reports,OAF,Oracle Apps
Home » APPS QUERIES » Query to Check to see what Indexes are on Table
Hello There,
ReplyDeleteQuery to Check to see what Indexes are on Table being contrived to exist for many projects simply so it can be run will be the first to hit the wall, but those projects where the functions to make existing transactions cheaper in real world applications will find the elusive real world demand.
1) This is my question that needs to be answered.
option or create a simple materialized view.
It was cool to see your article pop up in my Google search for the process yesterday. Great Guide.
Keep up the good work!
Thank you,
Bindu
Hello There,
ReplyDeleteSeems like I won the lottery here….This is a treasure box of blogs and your folks are like leprechauns! Phenomenal read on Query to Check to see what Indexes are on Table !
I am getting ORA00909 when i try to run my query with the following CASE WHEN statement:
CASE WHEN AV4.ALLOC_GRP_NO IN (SELECT ALLOC_GRP_NO FROM QRMTIPS.QCTRL_ALLOC_GRP_PROFILE WHERE
DISP_CD = 'WHDV' GROUP BY ALLOC_GRP_NO
HAVING COUNT(DISTINCT(MTR_SPLIT_NO)) > 1) THEN SUM(AV4.GAS_VOL,0) ELSE
NVL(av4.gas_vol, 0) END AS ALLOC_MM_GAS
Excellent tutorials - very easy to understand with all the details. I hope you will continue to provide more such tutorials.
Thank you,
Preethi.
You make so many great points here that I read your article a couple of times. Your views are in accordance with my own for the most part. This is great content for your readers. script cek mutasi
ReplyDeleteRound and U-formed desks alongside rectangular desks are famous decisions for office gatheringsGE APPLIANCE REPAIR & SERVICE IN SANTA BARBARA
ReplyDelete