RE: Too many rows reported for index in tkprof

oracle-l-bounce@xxxxxxxxxxxxx gravou em 2005-08-10 11:47:49:

> Thanks for this.  It is isn't from the PeopleSoft Query tool.

        I should have told you, but it is actually a view created by our
developers in PeopleSoft.  I don't know which tools they used.  Identation
and aliases are mine as I can't really live with badly idented SQL and
arbitrary aliases.


> SQR, but it is more likely to be from a different external system that
is
> referencing PeopleSoft, because the tables are qualified with 'sysadm.'.

        Actually this is where PS was installed here.


> I would also suggest changing the 'unique key' index on PS_VENDOR
> from CREATE UNIQUE  INDEX PS_VENDOR ON PS_VENDOR (SETID, VENDOR_ID) ...
> to   CREATE UNIQUE  INDEX PS_VENDOR ON PS_VENDOR (VENDOR_ID, SETID) ...
> So if someone forgets to specify SETID you can still search by
VENDOR_ID.

        What does setid mean?  Because if I do that I fear I could be
masking problems now which could resurface later...


> give a single character index ID.  App Designer allocated the first
unused
> letter for each index.  X is the 24th letter of the alphabet.  Are there
> really 24 user indexes?  There are only 4 specified in the vanilla
> application.  What has been going on?

        This is just a test index I created to try to fix the query in a
test database.

        Thanks a lot for your thorough analysis, I am implementing your
suggestions now!


--
Leandro Guimarães Faria Corcete DUTRA
Administrador de Bases de Dados      +55 (11) 4390 5383
Toyota do Brasil Ltda              ldutra@xxxxxxxxxxxxx
São Bernardo do Campo, SP                        BRASIL


This message (including any attachments) is confidential and may be privileged 
and intended solely for the use of the person/entity to whom it is addressed. 
If you have received it by mistake please notify the sender by returning via 
e-mail as well as delete this message from your system. Any unauthorized use or 
dissemination of this message in whole or in part is prohibited. Please note 
that e-mails are susceptible to change. TOYOTA DO BRASIL LTDA (including its 
group companies) shall not be liable for the improper or incomplete 
transmission of the information contained in this communication, neither for 
personal, nonbusiness related information nor opinion sent through this email 
or even for any delay in its receipt or damage to your system. TOYOTA DO BRASIL 
LTDA (or its group companies) does not guarantee that the integrity of this 
communication has been kept nor that this communication is free of viruses, 
interceptions or interference.
--
http://www.freelists.org/webpage/oracle-l

Other related posts: