Runtime Index Selection in static queries

  • Thread starter Thread starter mfurgal
  • Start date Start date
Status
Not open for further replies.
M

mfurgal

Guest
If an index is added online, only dynamic queries will be aware of the index and use the index. For static queries to use the new index, r-code needs to be recompiled. This defeats the ability to realistically add indexes online. This affects the 24x7x386 operation of the database

Continue reading...
 
Status
Not open for further replies.
Back
Top