|
Dear all, I face this strange problem when I run this query in STRSQL. SELECT * from kldadbfi3/norio10l WHERE PIPPO = '220215' This query takes 10 seconds to return the results (just 1 record which satisfies ) Where as the query SELECT * FROM kldadbfi3/norio10l WHERE nnureg= 662631 Takes only 3 seconds Both these queries selects the same record ...means NNUREG = 662631 & PIPPO = '220215' are of the same record Norio10l is a logical file with PIPPO as one of the keys. Does the SQL discriminate between the field that is used in the WHERE clause? Thanks In Advance, Regards, S.Chand DISCLAIMER: This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.