Christoph Weser wrote: > Hello Everyone! > > I know this question is quite general, anyway: > > Let's say I have a table for an authorization management. > There a table > "user" containing all information about users like name, ID, > language and so > on. > In "my real world" there are 100, maybe 200 different users a > lot, which > means 100 (or 200) rows in this table. > > So the question: Would it be a good idea to "waste" some > space for indices > in this case or will do the database anyway a table scan? Is > there a way how > I can estimate if a index is woth the space or not? > > Sorry if it's some vague, but every comment is highly appreciated! > > Thanx > > Chris
Hi, you could check the usage of an index with a look into column INDEX_USED in the system table INDEXES. So create the index, run your application and see if it is used. Kind regards Holger -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
