Hi,
have been looking at filter_predicates from sql_plan and can see a query that has a filter_predicate of
("T1"."PRODUCT_ID" IS NULL AND "T1"."PARENT_SKU_ID" IS NULL)
is it possible to create the above as an index
regards
index creation
Moderator: Tim...
2 posts
• Page 1 of 1
index creation
by newtooracle » Wed Mar 20, 2013 3:38 pm
- newtooracle
- Senior Member
- Posts: 81
- Joined: Mon Dec 21, 2009 9:05 am
Re: index creation
by Tim... » Wed Mar 20, 2013 4:06 pm
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
- Tim...
- Site Admin
- Posts: 16781
- Joined: Mon Nov 01, 2004 5:56 pm
- Location: England, UK
2 posts
• Page 1 of 1
Return to Oracle Database Administration
Who is online
Users browsing this forum: No registered users and 1 guest