| performance [message #372430] |
Tue, 13 February 2001 02:24  |
nikita
Messages: 2
Registered: February 2001
|
Junior Member |
|
|
|
I am having 2,00000 entries in a table. Suppose I retrieve 20,000 then 40,000 then 60,000 rows it gives diff times . Is there any reason for this. How it works internally
|
|
|
|
| Re: performance [message #372433 is a reply to message #372430] |
Tue, 13 February 2001 10:00  |
rajesh
Messages: 173
Registered: November 1998
|
Senior Member |
|
|
hi,
well, each time ur query is doing table scan or refering ur index, number of rows it retireves varies on each query. If ur table is properly indexed, will go to the index properly read it fetch the rows as per the index.Index is more or less acting as pointer. If it is not it does a full table scan for your query will consume time.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
