Re: Primary Index
Thanx Les, Brian. I was just thinking out loud. Schalk. On Mon, 26 Apr 2004 11:06:14 +0100, Les Hewkin <[EMAIL PROTECTED]> wrote: BUT if you really want to see the primary Index.. Create a secondary index on the ID of the file. Les (I'm sure it was Brian that tolds me to do that) Hewkin -Original Message- From: Brian Leach [mailto:[EMAIL PROTECTED] Sent: 26 April 2004 10:43 To: 'U2 Users Discussion List' Subject: RE: Primary Index uniVerse has no primary index. All items are stored using a hashing algorithm applied to the primary key so there is no need to index it. The only way to access these is to SELECT the file. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Schalk van Zyl Sent: 26 April 2004 10:35 To: U2 Users Discussion List Subject: Primary Index I can access a file containing the Secondary indecis, but is it possible to access the Primary index file? Schalk van Zyl - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JGD Smit, JF Jacobs, AO Müller, JW Smit, JP Snyman, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A Müller, Sekr/Secr: E van Niekerk. Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/ - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JGD Smit, JF Jacobs, AO Müller, JW Smit, JP Snyman, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A Müller, Sekr/Secr: E van Niekerk. Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Primary Index
BUT if you really want to see the primary Index.. Create a secondary index on the ID of the file. Les (I'm sure it was Brian that tolds me to do that) Hewkin -Original Message- From: Brian Leach [mailto:[EMAIL PROTECTED] Sent: 26 April 2004 10:43 To: 'U2 Users Discussion List' Subject: RE: Primary Index uniVerse has no primary index. All items are stored using a hashing algorithm applied to the primary key so there is no need to index it. The only way to access these is to SELECT the file. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Schalk van Zyl Sent: 26 April 2004 10:35 To: U2 Users Discussion List Subject: Primary Index I can access a file containing the Secondary indecis, but is it possible to access the Primary index file? Schalk van Zyl - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JGD Smit, JF Jacobs, AO Müller, JW Smit, JP Snyman, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A Müller, Sekr/Secr: E van Niekerk. Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Primary Index
uniVerse has no primary index. All items are stored using a hashing algorithm applied to the primary key so there is no need to index it. The only way to access these is to SELECT the file. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Schalk van Zyl Sent: 26 April 2004 10:35 To: U2 Users Discussion List Subject: Primary Index I can access a file containing the Secondary indecis, but is it possible to access the Primary index file? Schalk van Zyl - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JGD Smit, JF Jacobs, AO Müller, JW Smit, JP Snyman, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A Müller, Sekr/Secr: E van Niekerk. Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users