Time taken for insertion into a table

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • kedardkulkarni
    New Member
    • Feb 2007
    • 1

    Time taken for insertion into a table

    Does insertion into a table take longer if the number of records is significantly high? The table I refer to has only the primary key as index and the primary key is a sequence generated number. My table currently has about 90 million rows
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    having a Primary key or an index has no effect on insert operation.
    It helps in retrival .
    If the no of record is more definately it will take more time.

    Comment

    Working...