|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
August 30th, 2006, 11:51 AM
|
|||
|
|||
|
Different Index Creation Method Diff.
I want to know that is there any difference between these two set of queries
1. CREATE INDEX IDX_COMPANIES1 ON COMPANIES(ID,NAME); 2.------------------------------------------------------- CREATE INDEX IDX_COMPANIES1 ON COMPANIES(NAME); CREATE INDEX IDX_COMPANIES1 ON COMPANIES(ID); 2.-------------------------------------------------------
|
|
#2
August 30th, 2006, 11:58 AM
|
||||
|
||||
|
The second one is actually two statements, the second of the two should fail (duplicate name)
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Different Index Creation Method Diff. |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
