Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Does SQL 2000 have a query re-write function?

Status
Not open for further replies.
MDA

MDA

Technical User
Jan 16, 2001
243
US
Hi all,

There is a function in Oracle called query re-write... I am wondering if SQL 2000 has a similar function.

I have a aggreagate view linked to a table and I need SQL to direct the query to the aggregated table.

I am reviewing a new product that promises to speed up our databases by about 90% by creating aggreagted table views.. It looks very cool but my application cannot be changed to use certain tables, so I need this to happen by the SQL engine.

Any ideas about this??

Regards,

Mike
 
Status
Not open for further replies.

Similar threads

MathiasB
  • Locked
  • Question
Parameterised sql server query
Replies
8
Views
651
Chriss Miller
C
Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
739
Chris Miller
Chris Miller
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
1K
pjw001
pjw001
V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
902
Volvere
V
grnzbra
  • Locked
  • Question
Create Function Within IF statement. 1
Replies
4
Views
2K
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top