Hi, In responce to this then:
"No, search not. But inserting / updating / deleting rows will become slower, because additional indexes need to be maintained." how would i stop the auto-index creation when i've already explicitly created the same index? thanks m On Tuesday, 20 September 2011 07:09:43 UTC+1, Thomas Mueller wrote: > > Hi, > > 1) does H2 db, creates it's own indexes for primary key and unique >> constraints, automatically? >> > > Yes. > > >> 2) if we also create our own indexes with different names for same >> primary-key , >> will it still allow 2 indexes ( different names) for same primary >> key, >> > > Yes. > > >> if so, does search becomes little slow.. > > > No, search not. But inserting / updating / deleting rows will become > slower, because additional indexes need to be maintained. > > Regards, > Thomas > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/eosvWdVibtMJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
