Alexander Lohse wrote:
>
> when I use phpPgAdmin to create DBs, my Indices are getting automatic
> names like : pers_UID_key
>
> I am getting confused about the name!
>
> Does that mean a need to do call this in a select query?
>
> "select * from pers where pers_UID_key = '...'"
>
> or do i call the original field?
>
> "select * from pers where UID= '...'"
In relational databases you should not care much about indices when
writing simple queries. They are used automagically by the query
planner according to need. Many times the planner will do a better job
of improving performance than a common programmer. And if you decide to
change your indices, there's no need to rewrite your programs and queries.
I would recommend that anyone coming to relational databases read "An
Introduction to Database Systems", 7th Ed, by Chris J Date -
Addison-Wesley, October 1.999, ISBN 0201385902; around US$ 58 used, US$
72 new. The relational world is very, very different from "navigational
databases", and even if it is far simpler for the user it takes some
getting used to by programmers.
--
_
/ \ Leandro Guimarães Faria Corsetti Dutra +55 (11) 3040 8913
\ / Amdocs at Bell Canada +1 (514) 786 87 47
X Support Center, São Paulo, Brazil mailto:[email protected]
/ \ http://terravista.pt./Enseada/1989/ mailto:[email protected]
