Pick a dict item do create.index dictitem no nulls dop build.index filename dictitem (locks the file when running) will speed up select by loads and loads
bob -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Amit Bhutani Sent: 19 May 2004 10:40 To: [EMAIL PROTECTED] Subject: RE: [U2] Cost of Oracle vs PICK Hi group, Can any body let me know about the INDEX, y to use it and what are the benefits of using it. What is the importance of LIST.INDEX, SET.INDEX, CREATE.INDEX, BUILD.INDEX, DISABLE.INDEX commands. I think they are to speed up the search. Please reply me asap. Need urgent and detailed answer.. Thanks Amit ------- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ ------- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
