[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] Re: Oracle Insert/Select From issue
- Subject: [sqr-users] Re: Oracle Insert/Select From issue
- From: David Donnelly <Dave@isisbio.com>
- Date: Wed, 28 Sep 2005 07:29:50 -0700
- Delivery-date: Wed, 28 Sep 2005 09:30:32 -0500
- In-reply-to: <E1EKZjI-0005Ul-00@seldon.sqrug.org>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Ed,
I don't have a specific suggestion, and I don't do Peoplesoft, but I have
been whacking SQR for 15 years now, and EVERY time this has happened to me
it has turned out that I have either done something that has made it
impossible for Oracle to use an index, or there's a problem with a
date. Review the list of things that will cause Oracle not to use an
index. Look carefully at each use of an index field in the query, and make
sure you're not using it in a function (even implied).
I don't use date variables much. If you do, consider transparent
conversions being done from string.
Try replacing all variables with constants and see what happens. Get
"explain plan" output from SQL*Plus and see if it suggests anything -- it
will certainly tell you what the crucial index is.
Dave
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users