A serial column will lead to evenly distribution of data but If this column is not used for actual joining or access the row then it will lead to performance penalty because reading a row will require fulltable scan.
Joining becomes more efficient if the joined columns are also the primary...
Help database yourdatabase: For listing of all database objects,
Help table yourtable: For listing of all table columns,
Show table yourtable: For DDL statement.
Anil
try this one.
go to c:\winnt\system32\drivers\etc
open the host file and place the entries
127.0.0.1 localhost demo1099cop1 dbc cbccop1
X.X.X.X( Machines IP) Machinename MachineNamecop1 MachineNamebynetc dbccop1
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.