SQL questions
From: Magick <hack_at_netcom.com>
Date: Tue, 13 Sep 1994 05:42:34 GMT
Message-ID: <hackCw1zuz.K5D_at_netcom.com>
Date: Tue, 13 Sep 1994 05:42:34 GMT
Message-ID: <hackCw1zuz.K5D_at_netcom.com>
- what is the maximum number of allowed columns per table. I am trying to talk the application developer out of a table with 6200+ columns and would be grateful if someone could provide me with a reference.
- when creating a non-unique index on a table for a column which is either null or some value, will index entries be created for the rows whose indexed column value is null?
- one of the tables being created is timestamped and the end users want to access, for example, the last ten rows added. Except for trying to create a descending index, doing a massive sort in descending order (this will be a very large table) or trying to manipulate the date into a character or number which would be inserted into the key (reversing the date order), does anyone know of an easier or, more importantly, a more efficient method of doing this which reduce the overhead of the select statement?
Thanks in advance!!!
Elaine
-- replies to: hack_at_netcom.com Disclaimer: the opinions expressed here do not necessarily reflect any known standards of thought and may not make any sense whatsoever...Received on Tue Sep 13 1994 - 07:42:34 CEST