Databases uses statistics about data to determine the best way to query tables. Should the database seek or scan? How many rows will be returned from tables that are being joined? Oracle is no exception, but the way Oracle treats statistics is different from SQL Server.
Continue reading here by +Jeremiah Peschka
No comments:
Post a Comment
Note: only a member of this blog may post a comment.