RE: Too many rows reported for index in tkprof

oracle-l-bounce_at_freelists.org 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_at_toyota.com.br
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