One of the most important features that makes DBMS a better choice over a traditional file system is fast retrieval of data, which is facilitated by indexes. In a relational database every table can have at most
One rumor I have heard is that all DBMS's do not implement primary keys in the same fashion and because of that, if you wanted to create a cross platform, cross application database application, you could not use primary keys, but instead would need to put a unique constraint on th...
Roughly how long will indexing take? Can the database be used during the indexing? For information - we have no space left to add more devices (eg external disk) - all vdevno numbers have been used (checked sp_helpdevice command)Sort by date Sort by votes Jan 9, 2007 #2 MadHatter...