Ralf Liebenow wrote: > Is there any way to setup the ordering used by an > (character) Index ? I mean > specifying the used charset and whether an index is case > insenititve or > not, at index creation time ? > > Consider this: one has a table with person data (name, > firstname, city etc), > and in all columns the data must be stored case sensitive. > Then u want a > admin application where a user can search easyly all text > fields ... this > search should be done case insensitive. If this table has a > million rows, > searches using an index could be much much faster than > doing tablescans. > But if i want to use an index, i have to double all columns > to store there > the case insensitive version of the real columns, > effectively doubling > the table size ... > > So it would help much, if one could specify how the index would be > created, which charset would be used for the index etc ... > > I mean indexes are there to speed up searching ... and many > real live > applications need special ordering to use an index, > otherwise they are > useless ... > > Is it much work to enhance index creation syntax/code for > ordering support ?
Let say it this way: create index syntax : peanut create index code : not too bad but: every insert/update/delete which has to change this index has to know the function/the case-insensitivity : oops and every select, no matter how complex it is, has to be aware of the fact that this is not a 'normal' index, but one which should be used if ordering is done with the same function, but not possible if not exactly the same function is specified. It is not possible in every WHERE-case for this column(s), and so on : double-oops Altogether: it is much work, more than we can afford, although we understand the problem. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
