I'm currently working on an exercise for a class whose focus is on network storage. The assignment's problem is clear to me, but don't know where to start as far as solutions. If someone could lead me in the right direction and perhaps suggest a technology that might be appropriate for the...
I know how to distribute a group of layers evenly (link them all together, then press one of the 3 distribute evenly buttons), but I don't always know how to get the result I'm looking for. For example, how would I go about distributing a group of layers (say, 5 or 6 words that will be links on...
I was just looking over this site:
http://www.tizag.com/mysqlTutorial/mysql-index.php
So, aside from optimizing queries, the indexing is as easy as adding something like this, "INDEX (employeeID)" at the creation of the table?
I've done some research on optimizing mysql queries (and yes, r937, mysql is what I am using), and I think it's starting to sink in a little bit. I read about an example of indexing surname and firstname, which makes sense to me. I'm having some trouble applying the logic to this particular case...
Thanks for the fast response, r937. What exactly do you mean by indexing my foreign keys? RoomNum and CustNum are both integers, and with Date, I'm not exactly sure how I would go about doing that. Or are you just talking about queries with that comment? Sorry if this is a dumb question.
Hello there,
I'm pretty rusty with SQL (though I never had a great deal of experience to begin with), and I'm having a lot of trouble with slow search speeds of my database. I was hoping someone could tell me what I'm doing wrong as far as the schema goes.
The main function of this database...
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.