rhishi20 Posted January 2, 2014 Share Posted January 2, 2014 please suggest a website which offers tables and asked queries related to it. Link to comment Share on other sites More sharing options...
niche Posted January 2, 2014 Share Posted January 2, 2014 Why not just practice using your own examples and get help when you need it? Link to comment Share on other sites More sharing options...
davej Posted January 2, 2014 Share Posted January 2, 2014 There are a number of sample databases available online but less in the way of teaching best practices. Most tutorials are simply focused on teaching all of the available operations that can be performed without regard for the effect these operations might have on system performance. In order to improve system performance you might be creating indexes or temporary tables or taking other steps to limit operations that create large disruptive transactions. Oracle seems to have some material discussing this sort of thing and I'm sure the broad techniques are applicable to any relational database. http://docs.oracle.com/cd/B19306_01/server.102/b14211/technique.htm Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now