Re: index already exists


"Dave Brown" wrote...

> Ahh I see, Would I have to specifically reference that new
> index name in my select statements or would the database
> engine use it automatically.

You shouldn't need to reference that index, as any DB with good optimization
rules should make use of any existing index if it can improve performance of
a select statement.

I don't know the inner workings of hsqldb, but what I can see after a quick
glance on its documentation, it should work just fine, without specific
references to the indexes.

// Bjorn A


.

Relevant Pages

  • cdt glossary 0.1.4
    ... This glossary seeks to limit lengthy misunderstandings ... basic database research and mathematics. ... When context matters, it is provided. ... It is /not/ the same as a reference. ...
    (comp.databases.theory)
  • RE: MSOWCF Dll File
    ... Tom, Thanks again. ... > options and any required references that were checked in the source database. ... > Data to create new linked tables, instead of importing existing linked tables. ... > fine without the reference. ...
    (microsoft.public.access.setupconfig)
  • Re: My switchboards wont work with WinXP !
    ... The Switchboard code you posted is, without a doubt, ADO code. ... order for that code to run properly as is a Reference must be set to ADO. ... the Switchboard form itself than the solution would be as easy as this: ... the database and you are up and running. ...
    (microsoft.public.access.forms)
  • RE: Question on Expressions
    ... Relational Database Design and Table Normalization ... provide a great deal of control to your application. ... Until you purchase a reference, you can find information on some of these ... Support WebCast: Database Normalization Basics ...
    (microsoft.public.access.gettingstarted)
  • cdt glossary 0.0.5
    ... data, database, object, normalisation. ... If you do have a useful reference, ... "Known facts that can be recorded and have implicit meaning." ... can have pointer values. ...
    (comp.databases.theory)